View Single Post
  #12  
Old 16th September 2010, 11:18
vulfs vulfs is offline
Junior Member
 
Join Date: Dec 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default

#1054 - Unknown column 'web_list' in 'field list'

when I use the insert. think that where the error from the upgrade must be..

But I saw no errors under the upgrade...

Could be the web_list was added in another update, and this latest just assumes that table exists. I didnt see any prerequisist when i downloaded this latest.

What sql should i use to add web_list correctly?

The start of the insert looks like this:

INSERT INTO `isp_isp_web` ( `doc_id` , `doctype_id` , `web_host` , `web_domain` , `web_speicher` , `web_traffic` , `web_cgi` , `web_php` , `web_ssi` , `web_ftp` , `web_frontpage` , `web_mysql` , `web_list` , `web_listlimit` , `web_postgresql` , `web_shell` , `web_shop` , `web_phpmyadmin` , `web_webmail` , `web_webalizer` , `web_ssl` , `status` , `ssl_request` , `ssl_cert` , `ssl_action` , `web_ip` , `server_id` , `optionen_mysql_user` , `optionen_mysql_passwort` , `web_dns` , `web_userlimit` , `web_domainlimit` , `ssl_state` , `ssl_locality` , `ssl_organization` , `ssl_organization_unit` , `ssl_country` , `web_dns_mx` , `ssl_days` , `web_httpd_include` , `web_anonftp` , `web_anonftplimit` , `optionen_frontpage_passwort` , `optionen_mysql_remote_access` , `optionen_local_mailserver` , `web_faktura` , `optionen_logsize` , `optionen_directory_index` , `web_php_safe_mode` , `web_wap` , `web_standard_cgi` , `web_individual_error_pages` , `error_401` , `error_404` , `error_403` , `error_500` , `error_400` , `error_405` , `error_503` , `web_mysql_anzahl_dbs` , `web_mailuser_login` , `web_traffic_ueberschreitung` , `web_traffic_status` , `web_mysql_quota` , `web_mysql_quota_exceeded` , `web_mysql_quota_used_fract` , `web_mailquota` , `web_cgi_mod_perl` , `web_stats` , `webalizer_stats` )

Last edited by vulfs; 16th September 2010 at 11:22.
Reply With Quote