×
Kunena 5.1.7 Released - Security Release (20 Nov 2018)

The Kunena team has announce the arrival of Kunena 5.1.7 [K 5.1.7] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a Security release.

× This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Question Backing up website before upgrading and there is error while importing database. Need some help.

More
6 years 10 months ago - 6 years 10 months ago #1 by DTP2
Hello,

Today I wanted to test the upgrade from Kunena 1.7.1 to 1.7.2 and Joomla 1.7.3 to 2.5. Before this I made a backup of my website and database. This is something I did many times before, so I think there is nothing wrong here.

But while trying to re-import my database I got the error:

#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 '?phpMyAdmin=bb79a8da7b4bc6ce8bd83992983de09e' www.grafischforum.nl/5-overi ' at line 259

Line 259 in my sql file is:

`id` int(11) NOT NULL AUTO_INCREMENT,

Tried this on my local MAMP server as well as on the same webserver as the current forum is running. Both should be able to run this.

I've never seen this error, so guess this is something quite recent. Can someone tell me what I need to do to solve this issue? If I can get this fixed I can go on testing my forum on the new K and J software.

Can someone please help me and solve this issue?
Last edit: 6 years 10 months ago by DTP2.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #2 by Jiminimonka
Did you use Akeeba to backup your website? Perhaps you should roll it back, upgrade Joomla first, then upgrade Kunena once you have check no joomla modules/plugins need upgrading?

Please read the FAQ.
Only one question per topic.
Search before you ask a question.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #3 by DTP2
No, I just use phpmyadmin to export my database and Cyberduck (FTP) to backup my website. I've done this a dozen of times before the past couple of years.

On my local system I wanted to import everything, so I can perform and test the upgrade offline. This I've also done a dozen of times before the past couple of years.

Just this time it looks like Kunena or Joomla corrupted something that is now preventing normal behavior. I have no clue about databases, so I need someone that is willing to help me and fix this error.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #4 by Jiminimonka
So your live website is running fine?

Anyway, I can't help any further. I had absolutely no issue upgrading Joomla to 2.5 or Kunena from 1.7.1 to 1.7.2.

Perhaps you should check that its not an issue caused by J2.5 and some module that needs updating as well.

Please read the FAQ.
Only one question per topic.
Search before you ask a question.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #5 by DTP2
Yes, my live website is running fine, but before I do an upgrade I backup everything and test if the backup is working. But it looks like there is something corrupt in my live database that was not there the last time I made my backup. I do not make backup on weekly or even monthly base, so fall back to the last database without issues is no option.

Before I do the upgrade I want my backup/fallback to be 100%.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #6 by Jiminimonka
Then get Akeeba backup - its free and works perfectly.

Please read the FAQ.
Only one question per topic.
Search before you ask a question.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #7 by DTP2
Ik know Akeeba and know it works perfect. But if Joomla or Kunena put corrupt data in the database, also Akeeba will have issues one way or another. This is not about how I make my backups, because I do it this way for over 8 years now.

It's about the database error that I would like to have fixed. But thanks for your efforts and advise so far. It's appreciated.

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #8 by John
Did you try to select all tables and repair tables in phpmyadmin? Maybe that fixes your problem in the table?

My website: www.aquainfo.org

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #9 by 810
Or go to administrator/index.php?option=com_installer&view=database and click on fix.

regards 810

Please Log in or Create an account to join the conversation.

More
6 years 10 months ago #10 by DTP2
Hi 810. If I go to that url I get the following error:

500 - Er deed zich een fout voor.
View is niet gevonden [name, type, prefix]: database, html, installerView

If I search for the text from the error I get in the database file I notice that this line has another line that is not there in the lines around it. The line phpMyAdmin=JzU1q1OkQk%2CamG8IraxDVxqMH04 seems to be there without reason. I will delete it and see what happens.

Thanks so far.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.134 seconds