Print

[Quicky81]

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

[Stramm]

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.   

[Quicky81]

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

[Stramm]

post a link to your gallery for a start

make sure you uploaded all files replacing to original ones, then run update.php again

[Quicky81]

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.

[Stramm]

try again... I've run update.php.

[Quicky81]

Yes, thats it... it works... what have you done? 
I`ve run  http://www.teamphoenix.eu/gallerie/update.php to and it dosent work.
Thanks a lot Stramm, that was very fast support 

[Stramm]

I did the same... and it works

[Izzie Stevens]

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?

[Stramm]

you should start a new thread and post as much detail as possible