I was trying to restore my 2010 database, in SQL, but the following problem is coming up.
Quote:SQL query:
INSERT INTO mybb_adminlog( 'uid', 'ipaddress', 'dateline', 'module', 'action', 'data' )
VALUES (
'40', '117.198.178.62', '1262611679', 'user/users', 'ipaddresses', 'a:2:{i:0;s:5:\"21136\";i:1;s:7:\"jupower\";}'
);
MySQL said:
#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 ''uid','ipaddress','dateline','module','action','data') VALUES
58mb of backup, version is 1.4 of mybb.
$20 will be paid to the one, who will do this job. PM me if you can.
(2013-02-15, 11:24 AM)Longer Wrote: [ -> ]I was trying to restore my 2010 database, in SQL, but the following problem is coming up.
Quote:SQL query:
INSERT INTO mybb_adminlog( 'uid', 'ipaddress', 'dateline', 'module', 'action', 'data' )
VALUES (
'40', '117.198.178.62', '1262611679', 'user/users', 'ipaddresses', 'a:2:{i:0;s:5:\"21136\";i:1;s:7:\"jupower\";}'
);
MySQL said:
#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 ''uid','ipaddress','dateline','module','action','data') VALUES
58mb of backup, version is 1.4 of mybb.
$20 will be paid to the one, who will do this job. PM me if you can.
Have you tried to run that query ?
(2013-02-15, 12:10 PM)Spangle Wrote: [ -> ] (2013-02-15, 11:51 AM)Longer Wrote: [ -> ] (2013-02-15, 11:49 AM)Spangle Wrote: [ -> ] (2013-02-15, 11:24 AM)Longer Wrote: [ -> ]I was trying to restore my 2010 database, in SQL, but the following problem is coming up.
Quote:SQL query:
INSERT INTO mybb_adminlog( 'uid', 'ipaddress', 'dateline', 'module', 'action', 'data' )
VALUES (
'40', '117.198.178.62', '1262611679', 'user/users', 'ipaddresses', 'a:2:{i:0;s:5:\"21136\";i:1;s:7:\"jupower\";}'
);
MySQL said:
#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 ''uid','ipaddress','dateline','module','action','data') VALUES
58mb of backup, version is 1.4 of mybb.
$20 will be paid to the one, who will do this job. PM me if you can.
Have you tried to run that query ?
Tried, but can you?
It failed then ?
I guess, it shows the mentioned errors, that's why i came here.
(2013-02-15, 12:13 PM)Longer Wrote: [ -> ] (2013-02-15, 12:10 PM)Spangle Wrote: [ -> ] (2013-02-15, 11:51 AM)Longer Wrote: [ -> ] (2013-02-15, 11:49 AM)Spangle Wrote: [ -> ] (2013-02-15, 11:24 AM)Longer Wrote: [ -> ]I was trying to restore my 2010 database, in SQL, but the following problem is coming up.
58mb of backup, version is 1.4 of mybb.
$20 will be paid to the one, who will do this job. PM me if you can.
Have you tried to run that query ?
Tried, but can you?
It failed then ?
I guess, it shows the mentioned errors, that's why i came here.
The error looks as though you are trying to restore to a different version of MySQL, if you are trying to restore to MySQL5 from an earlier version, it may not work.
(2013-02-15, 12:29 PM)Spangle Wrote: [ -> ] (2013-02-15, 12:13 PM)Longer Wrote: [ -> ] (2013-02-15, 12:10 PM)Spangle Wrote: [ -> ] (2013-02-15, 11:51 AM)Longer Wrote: [ -> ] (2013-02-15, 11:49 AM)Spangle Wrote: [ -> ]Have you tried to run that query ?
Tried, but can you?
It failed then ?
I guess, it shows the mentioned errors, that's why i came here.
The error looks as though you are trying to restore to a different version of MySQL, if you are trying to restore to MySQL5 from an earlier version, it may not work.
What to do then for this version.
Thanks
I did, but it the backup doesn't change at all, even after uploading the older one.