I was recently adding a block from PortelZine.de called Last_Seen 1.62. With the included files came the SQL insert:
Quote
CREATE TABLE nuke_lastseen (
id int(15) NOT NULL auto_increment,
username text NOT NULL,
date int(15) NOT NULL default '0',
ip varchar(50) default NULL,
tag text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
)
I added that after changing the prefix to the suitable one for mine and backed up before i ran it. It all seemd fine and i installed and initialised the module. I was then looking through my databse in phpMyAdmin and saw many tables for modules i was not using.
I deleted them and backed up afterwards as all still seemed fine.
Now I get this on every darn page
Quote
ERROR: (getting user listYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Guest' at line 1
Chances are i deleted a table i should not have deleted, but then surely it would tell me that one was missing. I dont know how i could have messed up the code as i havent touched it!
Any help would be GREATLY appritiated as my site is rendered totally useless without a fix
- Phil
