I am trying to convert my punBB 1.2.13 to phpbb2 (2.0.22).
For some unknown reason I can't convert the users
Here's the type of error I get and... for each user:
Code: Select all
Couldn't insert user data
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 ' 2, '-5', 1, 'english', 'd M Y h:i a', 0, 0, 0, NULL, 1, 1, 0, 1, 1, 1, 1, 1, 0,' at line 2
INSERT IGNORE INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd)
VALUES (2, 1, 'Admin', ' ... etc. etc. ...
Here's the tables' structures I have:
(Please excuse me for this long message)
Code: Select all
CREATE TABLE phpbb_users (
user_id mediumint(8) NOT NULL default '0',
user_active tinyint(1) default '1',
username varchar(25) NOT NULL default '',
user_password varchar(32) NOT NULL default '',
user_session_time int(11) NOT NULL default '0',
user_session_page smallint(5) NOT NULL default '0',
user_lastvisit int(11) NOT NULL default '0',
user_regdate int(11) NOT NULL default '0',
user_level tinyint(4) default '0',
user_posts mediumint(8) unsigned NOT NULL default '0',
user_timezone decimal(5,2) NOT NULL default '0.00',
user_style tinyint(4) default NULL,
user_lang varchar(255) default NULL,
user_dateformat varchar(14) NOT NULL default 'd M Y H:i',
user_new_privmsg smallint(5) unsigned NOT NULL default '0',
user_unread_privmsg smallint(5) unsigned NOT NULL default '0',
user_last_privmsg int(11) NOT NULL default '0',
user_login_tries smallint(5) unsigned NOT NULL default '0',
user_last_login_try int(11) NOT NULL default '0',
user_emailtime int(11) default NULL,
user_viewemail tinyint(1) default NULL,
user_attachsig tinyint(1) default NULL,
user_allowhtml tinyint(1) default '1',
user_allowbbcode tinyint(1) default '1',
user_allowsmile tinyint(1) default '1',
user_allowavatar tinyint(1) NOT NULL default '1',
user_allow_pm tinyint(1) NOT NULL default '1',
user_allow_viewonline tinyint(1) NOT NULL default '1',
user_notify tinyint(1) NOT NULL default '1',
user_notify_pm tinyint(1) NOT NULL default '0',
user_popup_pm tinyint(1) NOT NULL default '0',
user_rank int(11) default '0',
user_avatar varchar(100) default NULL,
user_avatar_type tinyint(4) NOT NULL default '0',
user_email varchar(255) default NULL,
user_icq varchar(15) default NULL,
user_website varchar(100) default NULL,
user_from varchar(100) default NULL,
user_sig text,
user_sig_bbcode_uid varchar(10) default NULL,
user_aim varchar(255) default NULL,
user_yim varchar(255) default NULL,
user_msnm varchar(255) default NULL,
user_occ varchar(100) default NULL,
user_interests varchar(255) default NULL,
user_actkey varchar(32) default NULL,
user_newpasswd varchar(32) default NULL,
PRIMARY KEY (user_id),
KEY user_session_time (user_session_time)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE punbb_users (
id int(10) unsigned NOT NULL auto_increment,
group_id int(10) unsigned NOT NULL default '4',
username varchar(200) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
email varchar(50) NOT NULL default '',
title varchar(50) default NULL,
realname varchar(40) default NULL,
url varchar(100) default NULL,
jabber varchar(75) default NULL,
icq varchar(12) default NULL,
msn varchar(50) default NULL,
aim varchar(30) default NULL,
yahoo varchar(30) default NULL,
location varchar(30) default NULL,
use_avatar tinyint(1) NOT NULL default '0',
signature text,
disp_topics tinyint(3) unsigned default NULL,
disp_posts tinyint(3) unsigned default NULL,
email_setting tinyint(1) NOT NULL default '1',
save_pass tinyint(1) NOT NULL default '1',
notify_with_post tinyint(1) NOT NULL default '0',
show_smilies tinyint(1) NOT NULL default '1',
show_img tinyint(1) NOT NULL default '1',
show_img_sig tinyint(1) NOT NULL default '1',
show_avatars tinyint(1) NOT NULL default '1',
show_sig tinyint(1) NOT NULL default '1',
timezone float NOT NULL default '0',
language varchar(25) NOT NULL default 'English',
style varchar(25) NOT NULL default 'Oxygen',
num_posts int(10) unsigned NOT NULL default '0',
last_post int(10) unsigned default NULL,
registered int(10) unsigned NOT NULL default '0',
registration_ip varchar(15) NOT NULL default '0.0.0.0',
last_visit int(10) unsigned NOT NULL default '0',
admin_note varchar(30) default NULL,
activate_string varchar(50) default NULL,
activate_key varchar(8) default NULL,
PRIMARY KEY (id),
KEY users_registered_idx (registered),
KEY users_username_idx (username(8))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Thank you for your help
Yves