forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: Quicky81 on March 05, 2009, 03:36:39 pm
-
I have sucessfull updated my coppermine from 1.4.16 to 1.4.20.
Now i want to install stramms modpack 1.4.20 the first time.
I uploaded all files an run the update.php (it looks all rigth)
After that i refresh my gallery an became a Fatal Error:
I have activate the error loggin now with following result:
Fatal error :
While executing query "SELECT u.user_id AS id, u.user_name
AS username, u.user_password AS password, u.avatar_url AS
avatar_url, u.enable_admin_email AS notify,
u.auto_subscribe_post AS auto_subscribe_post,
u.auto_subscribe_comment AS auto_subscribe_comment,
u.user_group+100 AS group_id FROM
`db_phoenix`.gallerie_users AS u INNER JOIN
`db_phoenix`.gallerie_usergroups AS g ON
u.user_group=g.group_id WHERE u.user_id='2'" on Resource id #6
mySQL error: Unknown column 'u.avatar_url' in 'field list'
I have no clue what i do wrong. So please, can someone help me please?
thanks Quicky
-
The modpack out of the box is compatible just with the bridges mentioned in the announcement thread. If you use another one you need to adapt it to work together with the modpack. Search the modpack board for more info on how to do that.
-
Hu, i have no idea what you try to say to me. ???
I use the gallery without a bridge (standalone) an i have no mod installed (i think).
Could you please explain it what you mean?
P.S. I have seen that some datebase entrys are missed instead of an new 1.4.20 installation.
At example table "gallerie_users":
New System 1.4.20 with installed mod
Feld Typ Kollation Attribute Null Standard Extra Aktion
user_id int(11) Nein auto_increment
user_group int(11) Nein 2
user_active enum('YES', 'NO') latin1_swedish_ci Nein NO
user_name varchar(25) latin1_swedish_ci Nein
user_password varchar(40) latin1_swedish_ci Nein
user_lastvisit datetime Nein 0000-00-00 00:00:00
user_regdate datetime Nein 0000-00-00 00:00:00
user_group_list varchar(255) latin1_swedish_ci Nein
user_email varchar(255) latin1_swedish_ci Nein
user_profile1 varchar(255) latin1_swedish_ci Nein
user_profile2 varchar(255) latin1_swedish_ci Nein
user_profile3 varchar(255) latin1_swedish_ci Nein
user_profile4 varchar(255) latin1_swedish_ci Nein
user_profile5 varchar(255) latin1_swedish_ci Nein
user_profile6 text latin1_swedish_ci Nein
user_actkey varchar(32) latin1_swedish_ci Nein
auto_subscribe_post tinyint(4) Nein 1
auto_subscribe_comment tinyint(4) Nein 1
avatar_url varchar(255) latin1_swedish_ci Nein
user_pmsmail tinyint(4) Nein 1
enable_admin_email tinyint(4) Nein 1
My System 1.4.20 with installed mod
Feld Typ Kollation Attribute Null Standard Extra Aktion
user_id int(11) Nein auto_increment
user_group int(11) Nein 2
user_active enum('YES', 'NO') latin1_swedish_ci Nein NO
user_name varchar(25) latin1_swedish_ci Nein
user_password varchar(40) latin1_swedish_ci Nein
user_lastvisit datetime Nein 0000-00-00 00:00:00
user_regdate datetime Nein 0000-00-00 00:00:00
user_group_list varchar(255) latin1_swedish_ci Nein
user_email varchar(255) latin1_swedish_ci Nein
user_profile1 varchar(255) latin1_swedish_ci Nein
user_profile2 varchar(255) latin1_swedish_ci Nein
user_profile3 varchar(255) latin1_swedish_ci Nein
user_profile4 varchar(255) latin1_swedish_ci Nein
user_profile5 varchar(255) latin1_swedish_ci Nein
user_profile6 text latin1_swedish_ci Nein
user_actkey varchar(32) latin1_swedish_ci Nein
auto_subscribe_post tinyint(4) Nein 1
auto_subscribe_comment tinyint(4) Nein 1
avatar_url varchar(255) latin1_swedish_ci Nein
user_pmsmail tinyint(4) Nein 1
enable_admin_email tinyint(4) Nein 1
Thanks a lot
-
post a link to your gallery for a start
make sure you uploaded all files replacing to original ones, then run update.php again
-
http://www.teamphoenix.eu/gallerie/ (http://www.teamphoenix.eu/gallerie/)
If you are a guest you can see the startpage, and can try to look at the public gallery (this will end in failure: Critical error There was an error while processing a database query)
But when you log in you will see the failure (look in my first post).
I think it was a problem with the failed datenbase entrys (look at my second posting).
I have no clue how to fix it and why this is happend.
-
try again... I've run update.php.
-
Yes, thats it... it works... what have you done? :o
I`ve run http://www.teamphoenix.eu/gallerie/update.php to and it dosent work.
Thanks a lot Stramm, that was very fast support ;)
-
I did the same... and it works :)
-
I've the same problem too.
I update the Gallery and then I want to install the modd for the first time.
What I did wrong?
-
you should start a new thread and post as much detail as possible