Posted on: 10/24/06 05:17pm
By: trampoline
Tue 24 Oct 22:08:09 2006 - Attempting to install the User Page plugin Tue 24 Oct 22:08:09 2006 - Attempting to create User Page Admin group Tue 24 Oct 22:08:09 2006 - 1064: 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 '( uhp_id varchar(40) NOT NULL default '', uhp_uid mediumint( NOT NULL defa' at line 1. SQL in question: CREATE TABLE ( uhp_id varchar(40) NOT NULL default '', uhp_uid mediumint( NOT NULL default '1', uhp_title varchar(12 NOT NULL default '', uhp_content text NOT NULL, uhp_hits mediumint( unsigned NOT NULL default '0', uhp_date datetime NOT NULL default '0000-00-00 00:00:00', uhp_format varchar(20) NOT NULL default '', uhp_onmenu tinyint(1) unsigned NOT NULL default '0', uhp_label varchar(64) default NULL, owner_id mediumint( unsigned NOT NULL default '1', group_id mediumint( unsigned NOT NULL default '1', perm_owner tinyint(1) unsigned NOT NULL default '3', perm_group tinyint(1) unsigned NOT NULL default '2', perm_members tinyint(1) unsigned NOT NULL default '2', perm_anon tinyint(1) unsigned NOT NULL default '2', uhp_centerblock tinyint(1) unsigned NOT NULL default '0', uhp_tid varchar(20) NOT NULL default 'none', uhp_where tinyint(1) unsigned NOT NULL default '1', uhp_php tinyint(1) unsigned NOT NULL default '0', uhp_nf tinyint(1) unsigned default '0', uhp_inblock tinyint(1) unsigned default '1', PRIMARY KEY (uhp_id), KEY user_homepage_uhp_uid (uhp_uid), KEY user_homepage_uhp_date (uhp_date), KEY user_homepage_uhp_onmenu (uhp_onmenu), KEY user_homepage_uhp_centerblock (uhp_centerblock), KEY user_homepage_uhp_tid (uhp_tid), KEY user_homepage_uhp_where (uhp_where) ) TYPE=MyISAM
Posted on: 10/24/06 06:52pm
By: machinari