Support > cpg1.6 upgrading
upgrade from 1.5, installer and Google index
phill104:
A lot of people worry about databases. In essence all they are are files, just like any other. The only difference is they are not in the same place as your normal files. Most hosts provide tools to work with them that make everything easy, phpmyadmin is the more common one. Take a look in your hosts cPanel and I am sure you will find it. From there a few clicks is all it takes to make a backup and download it to your local machine.
littbarski:
Hello again.
I found now the area where I can manage my databases on my provider's website. I can export them as well, what I want to do, of course. I exported with the quick export option, but the advanced option also exists and I wonder if I should use it and what I should choose there. Here I show the options and how they are chosen by default.
I know it's in German, so perhaps somebody could give André a hint about this thread. Or maybe English speakers can also give me an answer, as many options show the English names as well.
or short question: is there anything very important to check in an export?
ron4mac:
You should be okay with just the quick option.
Only reason to do advanced is perhaps to choose 'Add DROP TABLE', which makes it a little easier to restore because you don't have to remove existing tables first.
littbarski:
hello, I made the upgrade and everything seems fine (although I did not yet test it after changing the PHP to 7), but the start page (index.php) gives an error. It is probably not in the theme. The log says:
ORDER BY ' in index.php on line 338 the following error was encountered:
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 '' at line 7
(and the error on the start page says in red:
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten)
I can open all albums and images, everything is there, so perhaps I just can change the start page parameters somehow? that it opens just a random image for example?
littbarski:
sorry, I did not show all the message:
21. Oktober 2018 um 14:25 - While executing query 'SELECT aid, title, r.description, keyword, alb_hits, category, visibility, r.thumb, r.owner, depth AS level, lft, '0' AS pic_count
FROM bildergaleriecategories AS c
INNER JOIN bildergaleriealbums AS r ON r.category = c.cid
WHERE c.depth >= 0 + 1
ORDER BY ' in index.php on line 338 the following error was encountered:
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 '' at line 7
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version