Welcome to Geeklog, Anonymous Saturday, June 15 2024 @ 05:27 pm EDT

Geeklog Forums

sql broken with mysql 4.013 ?


Jay

Anonymous
nerdy
first time user of geeklog. looks nice, does what i want.. doesnt have un-needed options. however on installing.. i got an error with the SQL script...
---------------------------------------- SQL-query :
MySQL said:

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 \'
 Quote

Jay

Anonymous
doesnt this site support cookies? crap!! SQL-query : * ? php$_SQL[1] = \" CREATE TABLE {$_TABLES[\'access\']} ( acc_ft_id mediumint(8) NOT NULL default \'0\', acc_grp_id mediumint(8) NOT NULL default \'0\', PRIMARY KEY (acc_ft_id,acc_grp_id) ) TYPE=MyISAM \" MySQL said: 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 \'
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Jay: doesnt this site support cookies? crap!!
Excuse me? Are you, by any chance, trying to run the contents of sql/mysql_tableanddata.php directly in MySQL (or phpMyAdmin)? That would be wrong (and wouldn\'t work). The proper way to install Geeklog is to create an empty database and then run the install script, which will set up the tables for you. If that\'s what you\'ve been doing, then you should have an entry in Geeklog\'s error.log file, corresponding to the SQL error you get, that lists the offending SQL request. Please quote that line from error.log. bye, Dirk
 Quote

All times are EDT. The time is now 05:27 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content