I have put together a new xml file and the new sql files.
When using the installer, it moves all the files to the correct locations, it then installs 2 tables, then I get a blank screen with the number 2 in the top left hand corner.
Its very strange because the sql file has 7 tables to be installed, so it gets through a little part of it, before the problem. So im guessing my problem is either with the install file, or the sql file. Below is the top half of the sql file, and the whole xml file.
Any suggestions where I might be going wrong, I cant see it for looking.
sql file it gets as far as installing hov_image and hov_my_notes but not any further.
Code:
#
# Drop Tables if they exist
#
DROP TABLE IF EXISTS `#__hov_image`;
DROP TABLE IF EXISTS `#__hov_my_notes`;
DROP TABLE IF EXISTS `#__hov_my_property`;
DROP TABLE IF EXISTS `#__hov_my_searchs`;
DROP TABLE IF EXISTS `#__hov_property`;
DROP TABLE IF EXISTS `#__hov_room`;
DROP TABLE IF EXISTS `#__hov_search`;
# --------------------------------------------------------
#
# Table structure for table `#__hov_image`
#
CREATE TABLE `#__hov_image` (
`image_id` int(11) NOT NULL auto_increment,
`property_id` int(11) NOT NULL default '0',
`image_name` varchar(32) NOT NULL default '',
`image_type` int(3) NOT NULL default '0',
PRIMARY KEY (`image_id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
# --------------------------------------------------------
#
# Table structure for table `#__hov_my_notes`
#
CREATE TABLE `#__hov_my_notes` (
`note_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`note` text NOT NULL,
`proper_id` text NOT NULL,
`name_id` text NOT NULL,
`date_added` int(11) NOT NULL default '0',
PRIMARY KEY (`note_id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
# --------------------------------------------------------
#
# Table structure for table `#__hov_my_property`
#
CREATE TABLE `#__hov_my_property` (
`hov_property_id` varchar(16) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00'
PRIMARY KEY (`note_id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
# --------------------------------------------------------
xml file
Code:
<files>
<filename>hov.php</filename>
<filename>hov.html.php</filename>
<filename>hov.class.php</filename>
<filename>hov.popup.php</filename>
</files>
<install>
<sql>
<file version="4.1.2">install.utf.sql</file>
<file version="3.2.0">install.nonutf.sql</file>
</sql>
</install>
<uninstall>
<sql>
<file version="4.1.2">uninstall.sql</file>
<file version="3.2.0">uninstall.sql</file>
</sql>
</uninstall>
<installfile>
<filename>install.hov.php</filename>
</installfile>
<uninstallfile>
<filename>uninstall.hov.php</filename>
</uninstallfile>
<administration>
<menu>HOV</menu>
<submenu>
<menu act="upload">Process HOV Data</menu>
<menu act="activate">Staging Activation</menu>
<menu act="live">Live Data</menu>
<menu act="notify">Search Notification</menu>
<menu act="conf">Edit Config</menu>
</submenu>
<files>
<filename>hov_proc_html.php</filename>
<filename>hov_proc.php</filename>
<filename>admin.hov.html.php</filename>
<filename>admin.hov.php</filename>
<filename>toolbar.hov.html.php</filename>
<filename>toolbar.hov.php</filename>
<filename>hov_config.php</filename>
<filename>install.utf.sql</filename>
<filename>install.nonutf.sql</filename>
<filename>uninstall.sql</filename>
</files>
</administration>
Login
Register
Rules
FAQ
The team
