Fatal Error: after install modpack 1.4.20 and update.php Fatal Error: after install modpack 1.4.20 and update.php
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Fatal Error: after install modpack 1.4.20 and update.php

Started by Quicky81, March 05, 2009, 03:36:39 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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:

QuoteFatal 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
QuoteFeld 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
QuoteFeld 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


Quicky81

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  ;)

Stramm


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