Pages: 1
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
Hi maeztro,
Maybe [extension by Eric] UserAdvManager, in the database :
update piwigo_plugins set state = 'inactive';
Offline
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
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
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
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
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
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
Pages: 1