Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Fatal Error: after install modpack 1.4.20 and update.php  (Read 5204 times)

0 Members and 1 Guest are viewing this topic.

Quicky81

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Fatal Error: after install modpack 1.4.20 and update.php
« 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:

Quote
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
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #1 on: March 05, 2009, 03:41:01 pm »

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

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #2 on: March 05, 2009, 04:11:22 pm »

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
Quote
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
Quote
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
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #3 on: March 05, 2009, 04:25:29 pm »

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

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #4 on: March 05, 2009, 04:57:46 pm »

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.
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #5 on: March 05, 2009, 05:02:35 pm »

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

Quicky81

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #6 on: March 05, 2009, 05:59:50 pm »

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

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #7 on: March 05, 2009, 06:04:15 pm »

I did the same... and it works :)

Izzie Stevens

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Female
  • Posts: 196
  • www.seriouslygreylovers.com
    • Seriously Grey Lovers
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #8 on: March 07, 2009, 07:33:27 pm »

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?
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Fatal Error: after install modpack 1.4.20 and update.php
« Reply #9 on: March 08, 2009, 11:16:19 am »

you should start a new thread and post as much detail as possible
Pages: [1]   Go Up
 

Page created in 0.09 seconds with 21 queries.