Q_LInks SQL error.

[jeffreyt]

Hi here,

When i try to run the "q_links_db_update.php" it gives this error....

Code: Alles auswählen

CREATE TABLE phpbb_q_links ( id mediumint(8) unsigned NOT NULL auto_increment, url text NOT NULL, name text NOT NULL, image text NOT NULL, description varchar(255) NOT NULL. seperator tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM
+++ Error: You have an error in your SQL syntax near '. seperator tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (`id`) ) TYPE=M' at line 6

INSERT INTO phpbb_q_links (url, name, image) VALUES ('http://www.oxpus.de', 'OXPUS', 'images/q_links/oxpus.gif')
+++ Error: Table 'jeffreyt_nl_-_jeffreyt.phpbb_q_links' doesn't exist

INSERT INTO phpbb_q_links (url, name, image) VALUES ('http://www.phpbb.com', 'phpBB', 'images/q_links/phpBB.gif')
+++ Error: Table 'jeffreyt_nl_-_jeffreyt.phpbb_q_links' doesn't exist

I'm using a fresh install.... Does someone knows what causses this problem?

Thanks in advance!
Jef

[oxpus]

Oh, sorry, little typo.
Look into the file:
At the end of the line

Code: Alles auswählen

description varchar(255) NOT NULL

will be a point ".". Replace this with a comma "," and the error will be fixed.
The mod downloadable from here is now fixed, too.

[jeffreyt]

Thanks opus,

I will try now!