g2 installation works fine but updater problem (8 -> 0.9.

knoebi

Joined: 2005-03-30
Posts: 3
Posted: Wed, 2005-03-30 15:09

Hi guys,

i'am a longtime gallery1 user and wanted to try out g2 to see if i could integrate it into my xoops2-based site.

installation works fine but when i try to upgrade (actual tgz or cvs) i allways get this error msg, on top of it it writes that i should post this to the gallery forum ;-)

any help would make me happy & thank you for your time!

philipp

Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1176 (MySqlDatabaseStorage::error)
* in modules/core/classes/GalleryStorage.class at line 241 (MySqlDatabaseStorage::execute)
* in modules/core/CoreModuleExtras.inc at line 212 (GalleryStorage::execute)
* in modules/core/module.inc at line 513 (CoreModule::upgrade)
* in modules/core/classes/GalleryModule.class at line 137 (CoreModule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 72 (CoreModule::installOrUpgrade)
* in upgrade/index.php at line 151 (UpgradeCoreModuleStep::processRequest)

cut out many debug lines, can email those if needed.

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
']
SET
g_parameterName = '_version'
WHERE

ADODB_mysql._Execute(
UPDATE
GalleryPluginParameterMap]
SET
...) % line 818, file: adodb.inc.php
ADODB_mysql.Execute(
UPDATE
GalleryPluginParameterMap]
SET
..., Array[2]) % line 1170,
file: DatabaseStorage.class
MySqlDatabaseStorage.execute(
UPDATE
GalleryPluginParameterMap]
SET
..., Array[2]) % line 241,
file: GalleryStorage.class
GalleryStorage.execute(
UPDATE
GalleryPluginParameterMap]
SET
..., Array[2]) % line 212,
file: CoreModuleExtras.inc
CoreModule.upgrade(Object:CoreModule, null,
Object:StatusTemplate) % line 513,
file: module.inc

realpath(/home/project/web-site/avamicitia/web-files/gallery2/modules/core/classes/../../../)
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-03-30 15:57

what was the previous version? alpha 2,3,4? i don't remember what core version 0.8 was...

and did it report any modified/missing files in installer step system check?
 
knoebi

Joined: 2005-03-30
Posts: 3
Posted: Wed, 2005-03-30 16:06

i didn't have installed a previous version at all!!

in the cvs version the installar was reporting ca. 42 modified files, but i thought that may be ok because i was using the cvs verison.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-03-30 16:47

i don't understand what you mean.
1. what does xoops have to do with this error? nothing.
2. in your first post you mention an update error from 0.8->0.9 and the error is actually an upgrade error. but now you say you didn't have installed a previous version?
so g2data and the database were empty, you copied the gallery2 files to the server and started the installer. once it was finished, it automatically started the upgrader? you followed then the upgrade steps until the core upgrade step and then you received this error?
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Wed, 2005-03-30 16:50

if you see the upgrader right after a new install then something has already gone wrong. try yesterday's nightly snapshot (today's may have a bug) and make sure the installer reports no modified files; then run the install making sure to use an empty db and empty g2data dir. if you still see the upgrader when the install completes you can PM me ssh/ftp access to your server and access to phpmyadmin and i can take a look.
 
knoebi

Joined: 2005-03-30
Posts: 3
Posted: Fri, 2005-04-01 07:08

thank you for your posts.

valiant:
so g2data and the database were empty, you copied the gallery2 files to the server and started the installer. once it was finished, it automatically started the upgrader? you followed then the upgrade steps until the core upgrade step and then you received this error?

yes. that is exactly what is happening here.

i tried to install g2 on another server and there it works. the problem seems to be. that when i install gallery it shows in the installing modules that the core version is 0.8. i don't know yet why this is so. i removed all versions of g2 from the server.

mindless:
i will try it myself to fix it, if i can't work it out i will pm you my login data.

thank all of you for your fast replies.

philipp
winterthur ;-)
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Fri, 2005-04-01 07:23

the upgrader says version 0.8 because the installer failed to write a versions.dat file (ie, the install core module failed, even if it didn't tell you so).