TOPIC: [SOLVED] Problem Installation: Please help!
[SOLVED] Problem Installation: Please help!
16 years 11 months ago #398
Anonymous
Topic Author
Visitor
Here is the scenario. I installed and uploaded the registration component, and received an error. I went to the instructions and found that I forgot to install the JEvent component, modules and bots. So I removed all traces of the registration component, from my database and file directories. I now re-upload my registration component and receive this error: SQL Error DB function failed with error number 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 13 SQL=CREATE TABLE IF NOT EXISTS `jos_dtregister_field_event` ( `id` int(11) NOT NULL auto_increment, `field_id` int(11) default NULL, `event_id` int(11) default NULL, `showed` tinyint(3) unsigned default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; SQL = CREATE TABLE IF NOT EXISTS `jos_dtregister_field_event` ( `id` int(11) NOT NULL auto_increment, `field_id` int(11) default NULL, `event_id` int(11) default NULL, `showed` tinyint(3) unsigned default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; Please help! Cheers
Hello. Did it install correctly the first time? I'm assuming it did then you got the error in the backend when setting up registrations. The backend will definitely give errors when JEvents is not in place. If it did install correctly the first time... did you completely drop all of the DT Register tables? What version of Joomla are you using? Any info you can provide may be helpful here. Thanks!