Hi all,
Here is my error Message after my upgrade
"
Piwigo encountered a non recoverable error
PWG_CHARSET and/or DB_CHARSET is not defined
#1 include_once /mnt/107/sdb/1/0/xxxxxxxphpwebgallery/index.php(26)
Fatal error: PWG_CHARSET and/or DB_CHARSET is not defined #1 include_once /mnt/107/sdb/1/0/xxxxxxx/phpwebgallery/index.php(26) in /mnt/107/sdb/1/0/xxxxxxx/phpwebgallery/include/functions_html.inc.php on line 690
"
I followed this procedure http://piwigo.org/doc/doku.php?id=en:he … er:upgrade but did not success...
Anybody has a solution? I can't reach anymore the website
Tx
Offline
Did you launch upgrade.php ?
May we have a copy of your ./include/mysql.inc.php (but ****** your password)?
Offline
Verify that your mysql.inc.php file in for structure of the file later upgrade:
<?php
$cfgBase = 'Base Name';
$cfgUser = 'base user';
$cfgPassword = 'pasword';
$cfgHote = 'localhost / base Address';
$prefixeTable = 'piwigo_'; (or your Prefix)
define('PHPWG_INSTALLED', true);
define('PWG_CHARSET', 'utf-8');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
?>
Offline
VDigital wrote:
Did you launch upgrade.php ?
May we have a copy of your ./include/mysql.inc.php (but ****** your password)?
Yes I did for sure. Nothing happened at first. Them i have added the requisted line and I got this error message.
Here is a copy of the file mysql.inc.php
"
<?php
$cfgBase = 'xxxxxxx';
$cfgUser = 'xxxxxxx';
$cfgPassword = '*******';
$cfgHote = 'sql.free.fr';
$prefixeTable = 'phpwebgallery_';
define('PHPWG_INSTALLED', true);
?>
"
Should I have to add all the missing lines as yours?
Tx
Offline
I have made the modifications as required but another error message has now appeared:
Warning: [mysql error 1146] Table 'frederic_regel.piwigo_config' doesn't exist
SELECT param, value
FROM piwigo_config
; in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php on line 919
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php on line 1144
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php on line 1149
Warning: [mysql error 1146] Table '****.piwigo_plugins' doesn't exist
SELECT * FROM piwigo_plugins
WHERE state="active" in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php on line 919
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions_plugins.inc.php on line 241
Warning: [mysql error 1146] Table '****.piwigo_sessions' doesn't exist
SELECT data
FROM piwigo_sessions
WHERE id = '52F029397c6be07f5e8270e9f5d73a74863b'
; in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php on line 919
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php:918) in /mnt/107/sdb/1/0/****/phpwebgallery/include/user.inc.php on line 29
Warning: [mysql error 1146] Table '****.piwigo_users' doesn't exist
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM piwigo_users
WHERE id = '2'
; in /mnt/107/sdb/1/0/****/phpwebgallery/include/functions.inc.php on line 919
and so on...
What should I have to do?
Thanks
Offline
Yes
$prefixeTable = 'phpwebgallery_';
define('PHPWG_INSTALLED', true);
define('PWG_CHARSET', 'utf-8');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
Offline
It seems we have posted at the same time...
So as I wrote above, I modified the file and an new error appeared (see above).
If somebody has a solution...
Should I have to reinstall from scratch?
Tx
Offline
Never...
[mysql error 1146] Table '****.piwigo_users' doesn't exist
xxxxxxx_users table must exist
Check your mysql.inc.php
Maybe you should have this:
$prefixeTable = 'phpwebgallery_';
But apparently you have:
$prefixeTable = 'piwigo_';
=> You've run Install.php already.
Anyway we can solved this case as many others...
Try to correct your mysql.inc.php with:
$prefixeTable = 'phpwebgallery_';
Offline
VDigital wrote:
Never...
[mysql error 1146] Table '****.piwigo_users' doesn't exist
xxxxxxx_users table must exist
Check your mysql.inc.php
Maybe you should have this:
$prefixeTable = 'phpwebgallery_';
But apparently you have:
$prefixeTable = 'piwigo_';
=> You've run Install.php already.
Anyway we can solved this case as many others...
Nice! It works... Actually, I have a website in version 2.0 but with my previous design...
I think I have to correct some points perhaps in the administration menu?
Thanks for this
Try to correct your mysql.inc.php with:
$prefixeTable = 'phpwebgallery_';
Offline