Announcement

#1 2011-04-03 22:13:35

maeztro
Translation Team
2011-03-27
58

Gallery plugin area "frozen" after upgrade and activation of plugins

Website at: http://gallery.chaos.co.za/

Upgraded installation.
Re-activated plugins.
After activating one of the plugins (have not a clue anymore which one) I can not logout/in  anymore.

I just get the following error:
Warning:  [mysql error 1054] Unknown column 'I.adviser' in 'where clause'

select
  U.username as username,
  U.mail_address as mail_address
from
  pwg_users as U,
  pwg_user_infos as I
where
  I.user_id =  U.id and
  I.status in ('webmaster',  'admin') and
  I.adviser = 'false' and
  mail_address is not null
order by
  username
in /<removed path>/include/dblayer/functions_mysql.inc.php on line 654


Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at
/<removed path>/include/dblayer/functions_mysql.inc.php:653) in /<removed path>/include/user.inc.php on line 29

Warning: Cannot modify header information - headers already sent by (output started at
/<removed path>/include/dblayer/functions_mysql.inc.php:653) in
/<removed path>/include/page_header.php on line 98

Tried following advice as given elsewhere (http://piwigo.org/forum/viewtopic.php?pid=120533), but can't find the place to deactivate anything in the database.

Any clues?

Offline

 

#2 2011-04-03 22:20:03

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13192

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

Hi maeztro,

Maybe [extension by Eric] UserAdvManager, in the database :

Code:

update piwigo_plugins set state = 'inactive';

Offline

 

#3 2011-04-03 22:23:26

n0kS
Member
The Moon
2011-03-16
68

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

maeztro wrote:

Website at: http://gallery.chaos.co.za/

Upgraded installation.
Re-activated plugins.
After activating one of the plugins (have not a clue anymore which one) I can not logout/in  anymore.

I just get the following error:
Warning:  [mysql error 1054] Unknown column 'I.adviser' in 'where clause'

select
  U.username as username,
  U.mail_address as mail_address
from
  pwg_users as U,
  pwg_user_infos as I
where
  I.user_id =  U.id and
  I.status in ('webmaster',  'admin') and
  I.adviser = 'false' and
  mail_address is not null
order by
  username
in /<removed path>/include/dblayer/functions_mysql.inc.php on line 654


Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at
/<removed path>/include/dblayer/functions_mysql.inc.php:653) in /<removed path>/include/user.inc.php on line 29

Warning: Cannot modify header information - headers already sent by (output started at
/<removed path>/include/dblayer/functions_mysql.inc.php:653) in
/<removed path>/include/page_header.php on line 98

Tried following advice as given elsewhere (http://piwigo.org/forum/viewtopic.php?pid=120533), but can't find the place to deactivate anything in the database.

Any clues?

Hello, the problem is the plugin ContactFrom. Please deactivate this plugin to fix your problem.

Offline

 

#4 2011-04-03 22:30:41

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

maeztro wrote:

Website at: http://gallery.chaos.co.za/


Tried following advice as given elsewhere (http://piwigo.org/forum/viewtopic.php?pid=120533), but can't find the place to deactivate anything in the database.

Any clues?

I had to go into phpMyAdmin on my website control panel.  I couldn't do anything in the Piwigo browser admin panel.

ddtddt walked me through what I needed to do. :)

Offline

 

#5 2011-04-04 15:40:17

maeztro
Translation Team
2011-03-27
58

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

Thank  you everyone for the replies.

lisaviolet - I saw your thread (http://piwigo.org/forum/viewtopic.php?pid=120533)  but  could not follow the advice given.

n0kS - ContactFrom is one of the plugins that I reactivated without problems before the system bombed out.

After log out I now get the following on trying to log in again:
Cookies are blocked or not supported by your browser. You must enable cookies to log in.

Using phpMyAdmin:

plg - Something seems to have thrashed the database. It is full of EMPTY!?

Will attempt to do
update piwigo_plugins set state = 'inactive';
now, if I can find it.

After that, and if it does not work, I will restore the old database and see what happens.

Offline

 

#6 2011-04-04 15:59:18

maeztro
Translation Team
2011-03-27
58

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

My mistake on the database - looking at the wrong prefix.

Deactivated all plugins - same problem.

Will just do a reinstall from scratch - very recently moved hosts, and I have not added new content since the move. Will then attempt to isolate the offending plugin. Feedback as soon as I sort the issues.

Offline

 

#7 2011-04-04 15:59:33

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

I couldn't do anything using my browser.  I had to go into my website control panel (not piwigo's) and access the php databases there.  Once in, I was able to get to the plugins database and set them as inactive.

It was pretty hairy for a while. *lol*

Last edited by lisaviolet (2011-04-04 15:59:56)

Offline

 

#8 2011-04-04 21:56:31

maeztro
Translation Team
2011-03-27
58

Re: Gallery plugin area "frozen" after upgrade and activation of plugins

Hairy probably does not come near :-)

The following plugins caused problems:
Advanced Menu Manager
Advanced MetaData
GMaps
Random Header

Issue has now been resolved. Note to all - Save BACKUPS because BACKUPS saves!

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact