Importing a database via bigdump generates error:

[Sp32]

See if this was vbulletin I would be able to fix the piece of shit ipb is...

Anyway I have no clue what most of this means because I have never used ipb before but I really need some help so if anyone can please do!!!!

Error at the line 12: INSERT INTO sup_admin_login_logs (admin_id, admin_ip_address, admin_username, admin_time, admin_success, admin_post_details, ) VALUES('382','87.110.97.139','admin','1247623725','1','a:2:{s:3:"get";a:4:{s:6:"adsess";s:0:"";s:3:"app";s:4:"core";s:6:"module";s:5:"login";s:2:"do";s:14:"login-complete";}s:4:"post";a:3:{s:7:"qstring";s:0:"";s:8:"username";s:5:"admin";s:8:"password";s:8:"*******5";}}');
 Query: INSERT INTO sup_admin_login_logs (admin_id, admin_ip_address, admin_username, admin_time, admin_success, admin_post_details, ) VALUES('382','87.110.97.139','admin','1247623725','1','a:2:{s:3:"get";a:4:{s:6:"adsess";s:0:"";s:3:"app";s:4:"core";s:6:"module";s:5:"login";s:2:"do";s:14:"login-complete";}s:4:"post";a:3:{s:7:"qstring";s:0:"";s:8:"username";s:5:"admin";s:8:"password";s:8:"*******5";}}');

 MySQL: 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 ') VALUES('382','87.110.97.139','admin','1247623725','1','a:2:{s:3:"get";a:4:{s:6' at line 1

Sp32 Reviewed by Sp32 on 17th Jul 2009. Importing a database via bigdump generates error: See if this was vbulletin I would be able to fix the piece of shit ipb is... Anyway I have no clue what most of this means because I have never used ipb before but I really need some help so if anyone can please do!!!! <3<3<3<3<3<3 Rating: 5

[r0ck]

whats it look like at line 11 and 12 in sql?

[Sp32]

first line to the 14th line:

CREATE TABLE sup_admin_login_logs (
  admin_id int(10) NOT NULL AUTO_INCREMENT,
  admin_ip_address varchar(16) NOT NULL DEFAULT '0.0.0.0',
  admin_username varchar(40) NOT NULL DEFAULT '',
  admin_time int(10) unsigned NOT NULL DEFAULT '0',
  admin_success int(1) unsigned NOT NULL DEFAULT '0',
  admin_post_details text,
  PRIMARY KEY (admin_id),
  KEY admin_ip_address (admin_ip_address),
  KEY admin_time (admin_time)
) ENGINE=MyISAM AUTO_INCREMENT=383 DEFAULT CHARSET=latin1;
INSERT INTO sup_admin_login_logs (admin_id, admin_ip_address, admin_username, admin_time, admin_success, admin_post_details, ) VALUES('382','87.110.97.139','admin','1247623725','1','a:2:{s:3:"get";a:4:{s:6:"adsess";s:0:"";s:3:"app";s:4:"core";s:6:"module";s:5:"login";s:2:"do";s:14:"login-complete";}s:4:"post";a:3:{s:7:"qstring";s:0:"";s:8:"username";s:5:"admin";s:8:"password";s:8:"*******5";}}');
INSERT INTO sup_admin_login_logs (admin_id, admin_ip_address, admin_username, admin_time, admin_success, admin_post_details, ) VALUES('381','87.110.97.139','admin','1247619643','1','a:2:{s:3:"get";a:4:{s:6:"adsess";s:0:"";s:3:"app";s:4:"core";s:6:"module";s:5:"login";s:2:"do";s:14:"login-complete";}s:4:"post";a:3:{s:7:"qstring";s:0:"";s:8:"username";s:5:"admin";s:8:"password";s:8:"*******5";}}');
INSERT INTO sup_admin_login_logs (admin_id, admin_ip_address, admin_username, admin_time, admin_success, admin_post_details, ) VALUES('380','87.110.97.139','admin','1247605059','1','a:2:{s:3:"get";a:4:{s:6:"adsess";s:0:"";s:3:"app";s:4:"core";s:6:"module";s:5:"login";s:2:"do";s:14:"login-complete";}s:4:"post";a:3:{s:7:"qstring";s:0:"";s:8:"username";s:5:"admin";s:8:"password";s:8:"*******5";}}');

[r0ck]

mahhhh sorry I was betting the ; was missing at the end of line 11

[Sp32]

Ah damn, my server people think it might be due to a change of mysql version but I doubt it..

trying to find out what the previous sql version was from previous owner..

[Crucify]

try via ssh

[Sp32]

I just did and I got:

ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the m                                                                     anual that corresponds to your MySQL server version for the right syntax to use                                                                      near ') VALUES('382','87.110.97.139','admin','1247623725','1','a:2:{s:3:"get";a:                                                                     4:{s:6' at line 1

[r0ck]

weird


message to short

[Viz0n]

I'm no SQL expert, but the only thing i can think of is this:

INSERT INTO sup_admin_login_logs (admin_id, admin_ip_address, admin_username, admin_time, admin_success, admin_post_details, )

Why is there a , after admin_post_details?

[r0ck]

^ good point