Support > cpg1.6 upgrading
Where are my galleries?
KchoPrro:
Hello friends, I just updated from CPG 1.5.48 to CPG 1.6.19. I have followed the steps of the Installer Script and everything has gone correctly. At the time of linking to the database, you had the option of creating a new database or using the existing database. I decided to use the existing database, I added the username, password... I did the connection test with the database and it was correct. I thought that everything was well done (thanks for the Script!!!), but now I have no categories, no albums, no photos....
What happened? :o :-[
KchoPrro:
I keep a backup of the database.
KchoPrro:
--- Quote from: KchoPrro on August 13, 2022, 08:01:02 pm ---Hello friends, I just updated from CPG 1.5.48 to CPG 1.6.19. I have followed the steps of the Installer Script and everything has gone correctly. At the time of linking to the database, you had the option of creating a new database or using the existing database. I decided to use the existing database, I added the username, password... I did the connection test with the database and it was correct. I thought that everything was well done (thanks for the Script!!!), but now I have no categories, no albums, no photos....
What happened? :o :-[
I keep a backup of the database.
--- End quote ---
It's curious. I am checking my database. In it I see the "albums" table with all the albums from the previous CPG 1.5.48 gallery (all the images are also in "pictures"). Also, I see another table "cpg16x_albums" in which there is no data. I also see the table "cpg16x_pictures" in which there is no picture data.
I think the problem is that instead of updating the tables from version 1.5.48 to version 1.6.19, the two tables have been added directly, although currently it is only showing me the new tables from 1.6.19 in which no no data of any kind (I haven't uploaded anything). It seems strange to me, using the Script I told it to update the database from 1.5.48 to 1.6.19, I did not use the option to create the new data table.
Is it possible to solve this problem? Attached capture of the current database.
ron4mac:
You should not have done an install ... just an existing installation upgrade.
In your include/config.inc.php, change:
--- Code: ---$CONFIG['TABLE_PREFIX'] = 'cpg16x_';
--- End code ---
to:
--- Code: ---$CONFIG['TABLE_PREFIX'] = '';
--- End code ---
Then run the update script for your gallery...
https://www.adolfoventas.es/galeria/update.php
Once verified that your gallery is back, you can remove all the tables in your database that start with cpg16x_.
KchoPrro:
--- Quote from: ron4mac on August 14, 2022, 04:22:50 pm ---You should not have done an install ... just an existing installation upgrade.
In your include/config.inc.php, change:
--- Code: ---$CONFIG['TABLE_PREFIX'] = 'cpg16x_';
--- End code ---
to:
--- Code: ---$CONFIG['TABLE_PREFIX'] = '';
--- End code ---
Then run the update script for your gallery...
https://www.adolfoventas.es/galeria/update.php
Once verified that your gallery is back, you can remove all the tables in your database that start with cpg16x_.
--- End quote ---
Thanks for the reply. I ran the Script and I think it indicated that this was an update, not a fresh install.
I just made the indicated change. Unfortunately, now an error appears and I am afraid that it is related to the plugins (MiniCMS):
--- Quote ---Fatal error: Uncaught Error: Call to undefined function mysql_fetch_row() in /home/************/domains/adolfoventas.es/public_html/galeria/plugins/minicms/include/init.inc.php:55 Stack trace: #0 /home/************/domains/adolfoventas.es/public_html/galeria/plugins/minicms/codebase.php(132): require() #1 /home/*************/domains/adolfoventas.es/public_html/galeria/include/plugin_api.inc.php(307): minicms_page_start(NULL) #2 /home/**************/domains/adolfoventas.es/public_html/galeria/include/init.inc.php(439): CPGPluginAPI::action('page_start', NULL) #3 /home/*************/domains/adolfoventas.es/public_html/galeria/index.php(22): require('/home/*********...') #4 {main} thrown in /home/************/domains/adolfoventas.es/public_html/galeria/plugins/minicms/include/init.inc.php on line 55
--- End quote ---
https://www.adolfoventas.es/galeria/update.php
Navigation
[0] Message Index
[#] Next page
Go to full version