An error was encountered
File: /home/indocron/public_html/forums/install_mod.php
Line: 26
PunBB reported: Unable to add column "birthday" to table "users"
Database reported: 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 '-0-0' at line 1 (Errno: 1064)
NOOO!
Edit:
$db->query("ALTER TABLE ".$db->prefix."users ADD birthday varchar(10) NOT NULL DEFAULT 0-0-0") or error('Unable to add column "birthday" to table "users"', __FILE__, __LINE__, $db->error());
Should be
$db->query("ALTER TABLE ".$db->prefix."users ADD birthday varchar(10) NOT NULL DEFAULT '0-0-0'") or error('Unable to add column "birthday" to table "users"', __FILE__, __LINE__, $db->error());
Else it will parse it as 0 minus 0 minus 0, which just makes no sense
Edit:
$db->query("CREATE TABLE punn_calendar (id int(100) NOT NULL auto_increment, date date NOT NULL default '0000-00-00', title varchar(255) NOT NULL default '', body text NOT NULL, user_id int(100) NOT NULL default '0', UNIQUE KEY id (id))") or error('Unable to add table "calendar"', __FILE__, __LINE__, $db->error());
Should be
$db->query("CREATE TABLE ".$db->prefix."calendar (id int(100) NOT NULL auto_increment, date date NOT NULL default '0000-00-00', title varchar(255) NOT NULL default '', body text NOT NULL, user_id int(100) NOT NULL default '0', UNIQUE KEY id (id))") or error('Unable to add table "calendar"', __FILE__, __LINE__, $db->error());