Common Errors and problems

From GeeklogWiki

Common problems that arise when programming plugins for geeklog, and solutions or workarounds.

Install Errors

MySQL errors

On install, errors of the type "you have an error in your SQL near line 1 at [...]" when creating (usually) the first of your plugin's DB tables. If you have no errors in your SQL, then the problem is usually due to a problem with your quotes. The safest format to use is as below:

$NEWTABLE['glinks_submissions'] = "CREATE TABLE `{$_TABLES['glinks_submissions']}` (

 `lid` varchar(20) NOT NULL default ,

 `category` varchar(32) default NULL,
 `url` varchar(255) default NULL,
 `description` text,
 `title` varchar(96) default NULL,
 `hits` int(11) default NULL,
 `date` datetime default NULL,
 PRIMARY KEY  (`lid`)

) TYPE=MyISAM;";

Using the single quote character (as in PHP code generated by PHPMyAdmin) usually solves this installation error.

Runtime Errors