How can i solve phpmyadmin import issue

Klzone

Member
Registered
Joined
May 22, 2022
Messages
14
Points
3

Reputation:

How can i solve phpmyadmin

Version 2.2.5
static analysis: 3 errors were found during analysis. a new statement was found, but no delimiter between it and the previous one. (near "desc" at position 252) missing comma before start of a new alter operation. (near "add" at position 275) unrecognized alter operation. (near "add" at position 275)

-- -- indexes for table xf_post -- alter table xf_post add primary key (post_id), add key thread_id_post_date (thread_id,post_date), add key thread_id_position (thread_id,position), add key thread_id_score_date (thread_id,desc,post_date), add key user_id (user_id), add key post_date (post_date)
 

Klzone

Member
Registered
Joined
May 22, 2022
Messages
14
Points
3

Reputation:

error.jpg


If I back up xenforo files, do I have to comply with any rules and regulations?
Because I have an exported backup file, but I can not import in phpmyadmin
 

Attachments

  • backup.PNG
    backup.PNG
    31.2 KB · Views: 79
  • backupfile.jpg
    backupfile.jpg
    138.7 KB · Views: 83
Last edited:

thomsa

Moderator
Staff member
Moderator
S.V.I.P Member
Collaborate
Registered
Joined
Jun 22, 2019
Messages
1,066
Points
173

Reputation:

SNap!

Collaborate
Collaborate
Registered
Joined
Mar 17, 2022
Messages
555
Points
253

Reputation:

maybe an export issue, try it local

but version 2.2.5 old as hell, try to upgrade to higher version

which version you used for export and import (php/mysql/phpmyadmin)
 
Last edited:

Klzone

Member
Registered
Joined
May 22, 2022
Messages
14
Points
3

Reputation:

maybe an export issue, try it local

but version 2.2.5 old as hell, try to upgrade to higher version

which version you used for export and import (php/mysql/phpmyadmin)
SNap!
phpmyadmin version.PNG
 

Klzone

Member
Registered
Joined
May 22, 2022
Messages
14
Points
3

Reputation:

How can i solve phpmyadmin

Version 2.2.5
static analysis: 3 errors were found during analysis. a new statement was found, but no delimiter between it and the previous one. (near "desc" at position 252) missing comma before start of a new alter operation. (near "add" at position 275) unrecognized alter operation. (near "add" at position 275)

-- -- indexes for table xf_post -- alter table xf_post add primary key (post_id), add key thread_id_post_date (thread_id,post_date), add key thread_id_position (thread_id,position), add key thread_id_score_date (thread_id,desc,post_date), add key user_id (user_id), add key post_date (post_date)
KlzoneI'm tied can you explain how can i backup xenforo
Now i installed xenforo 2.2.9 it's working perfectly but if i backup and return importing time not working
Do you have any ideas
(Example now I'm using php one script platform it's backup and restoring importing also working )
Look like
 
Last edited:

Klzone

Member
Registered
Joined
May 22, 2022
Messages
14
Points
3

Reputation:

I'm tied can you explain how can i backup xenforo
Now i installed xenforo 2.2.9 it's working perfectly but if i backup and return importing time not working
Do you have any ideas
(Example now I'm using hosting reseller platform it's backup and restoring importing also working )
Look like
KlzoneIs there anyone who faces similar issues
 

SNap!

Collaborate
Collaborate
Registered
Joined
Mar 17, 2022
Messages
555
Points
253

Reputation:

can be closed
 

Klzone

Member
Registered
Joined
May 22, 2022
Messages
14
Points
3

Reputation:

BattleKing:

If you have to backup look like video method we will be face same issue

You have to backup picture method
 

Attachments

  • Screenshot_20220526-130757_Chrome.jpg
    Screenshot_20220526-130757_Chrome.jpg
    357.4 KB · Views: 78
Last edited:

sucre13

Moderator
Staff member
Moderator
Collaborate
Registered
Joined
Jan 19, 2019
Messages
836
Points
153

Reputation:

BattleKing:

If you have to backup look like video method we will be face same issue

You have to backup picture method
Klzonequestion do you use vps or shared hosting?
 
Top