Solved: Problem with Easy Install Scripts
Submitted by guilhermecardoso on Sat, 01/31/2009 - 21:19
Hi,
I'm having a problem with easy install scripts. Everytime i go there, i get this:Some Error Occured.
Error Occured (source:(tablolistele_3_5_4))err: query:select scriptname,homepage,description from scripts Unknown column 'homepage' in 'field list'last db error:Unknown column 'homepage' in 'field list'
Select script to install:
Unknown column 'homepage' in 'field list'
Is there anyway to fix this?
Cheers
ehcpdeveloper
Sun, 02/01/2009 - 00:18
Permalink
Re: Problem with Easy Install Scripts
That is caused by an un-upgraded table, scripts, table,
you need just to upgrade that table,
Future versions of ehcp will be mostly self-upgrading, meaning, adding necessary table fields,
sory fo that,
Solution:
Go to your phpmyadmin,
choose ehcp db,
click on sql,
copy and paste this:
ALTER TABLE `scripts` ADD `homepage` VARCHAR( 50 ) NULL ;
click go,
your ehcp db is fixed
guilhermecardoso
Sun, 02/01/2009 - 01:02
Permalink
I had fixed the sql table,
I had fixed the sql table, but now i get this output:
Some Error Occured.
Error Occured (source:(tablolistele_3_5_4))err: query:select scriptname,homepage,description from scripts Unknown column 'description' in 'field list'last db error:Unknown column 'description' in 'field list'
Select script to install:
Unknown column 'description' in 'field list'
The table "scripts" has this fields: id, host, scriptname, filetype, fileinfo, scriptdirtocopy, commandsaftercopy, homepage
Do i have to create "description" field?
Thanks
ehcpdeveloper
Sun, 02/01/2009 - 01:07
Permalink
do same for description
do same for description field,
sql:
ALTER TABLE scripts ADD description VARCHAR( 50 ) NULL ;
guilhermecardoso
Sun, 02/01/2009 - 01:46
Permalink
It's fixed now. Thanks
It's fixed now.
Thanks
ehcpdeveloper
Sun, 02/01/2009 - 12:13
Permalink
if anybody else lives same
if anybody else lives same situation,
to solve it in single step,
i suggest one of followings:
1- either, get newer ehcp files, overwrite with yours except config.php, re-login to ehcp gui,
2- or, just apply sql at http://www.ehcp.net/scriptsupdate.sql.html
sory that i did not say to you this easy step at start, i thought that you have a single field missing..
georgeb2005
Mon, 11/18/2013 - 17:18
Permalink
http://www.ehcp.net/scriptsupdate.sql
http://www.ehcp.net/scriptsupdate.sql
"Error/Hata
Page Not Found/Sayfa bulunamadı
Server powered by ehcp"
Some Error Occured.
Error Occured (source:(tablolistele_3_5_4))
err: query:select id,reseller,panelusername,maxdomains,maxemails,quota,maxpanelusers,maxftpusers,maxdbs,name,email from panelusers
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10' at line 1
last db error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10' at line 1
If you just upgraded your ehcp, try to logout, login back.
how can i repair the database ?
Or is not from database the problem ?
Soft gratuit http://www.nebunu.ro hosted on ehcp .
ehcpdeveloper
Mon, 11/18/2013 - 17:51
Permalink
http://www.ehcp.net
http://www.ehcp.net/scriptsupdate.sql
this file is not used now.
try logout&login back. this fixes some db problems.
if that does not help, try upgrading your ehcp.
use ehcp.net/ehcp_yeni.tgz file .
this is new testing version.
georgeb2005
Tue, 11/19/2013 - 09:23
Permalink
Solved
I setup adobd connection to mysqli in classapp.php $this->conn=NewADOConnection("mysql"); because "Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/new/ehcp/config/adodb/drivers/adodb-mysql.inc.php on line 443" then i put "error_reporting (E_ALL ^ E_NOTICE ^ E_WARNING ^ E_DEPRECATED);" end solved
Soft gratuit http://www.nebunu.ro hosted on ehcp .