Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
marion (Guest)
marion (Guest)
good morning, after upload files via ftp (binary), i can´t enter administration, and site is down with this error:
 
frontend: Page URL: http://www.xxxxx.com.ar/
Referrer URL:
Database error: Invalid SQL: SELECT setting_name,setting_value FROM va_global_settings WHERE (setting_type='global' OR setting_type='products') AND site_id=1
MySQL Error: Unknown column 'site_id' in 'where clause'
 
backend: Page URL: http://www.xxxxxx.com.ar/admin/
Referrer URL: http://www.xxxxx.com.ar/admin/
Database error: Invalid SQL: SELECT setting_value FROM va_global_settings WHERE setting_type='global' AND setting_name= 'site_url' and site_id=1
MySQL Error: Unknown column 'site_id' in 'where clause'
 
what´s the error?
 
on2dvd
on2dvd
First, you only upload in binary mode the "includes folder"
 
If you did that, the other thing might be that you need to clear your browser cache, I have found that sometimes works.
 
on2dvd
on2dvd
Although this does look like a site ID (for multisite) misconfiguration.
 
marion (Guest)
marion (Guest)
hi on2dvd, thanks for the reply, i clear the browser cache, but continue the error. I don't get multisite configuration in my site. how can i run de db upgrade?
 
Ned
Ned
Ive had this and it looks like the database hasn't got the correct data or the "includes/va_definition.php" is not communicating the right database name, host, user or password.
 
In my case I change the database name each time and copy data into it - but I forgot to change the definitions file Sad
 
Monk
Monk
Have you try the patch from
http://www.viart.com/fix_for_admin_common_php_for_release_3_5.html
as it seems it can be what you looking for?