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

Forums: 
ehcp Problems - After Installation

ehcpdeveloper

Sun, 02/01/2009 - 00:18

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

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

do same for description field,

sql:
ALTER TABLE scripts ADD description VARCHAR( 50 ) NULL ;

guilhermecardoso

Sun, 02/01/2009 - 01:46

It's fixed now.
Thanks

ehcpdeveloper

Sun, 02/01/2009 - 12:13

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

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

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

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 .