Solved: Problem with Easy Install Scripts

[guilhermecardoso]

Hi,

I'm having a problem with easy install scripts. Everytime i go there, i get this:
<code>Some Error Occured.
Error Occured (sourcetablolistele_3_5_4))err: queryelect 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'</code>

Is there anyway to fix this?

Cheers

Restored from old drupal forum, for user uid:1106 username:guilhermecardoso
You may reset your password to access your new account here.

[ehcpdeveloper]

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

Restored from old drupal forum, for user uid:1106 username:guilhermecardoso
You may reset your password to access your new account here.

[guilhermecardoso]

I had fixed the sql table, but now i get this output:
<code> Some Error Occured.
Error Occured (sourcetablolistele_3_5_4))err: queryelect 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'</code>

The table "scripts" has this fields: id, host, scriptname, filetype, fileinfo, scriptdirtocopy, commandsaftercopy, homepage
Do i have to create "description" field?

Thanks

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[ehcpdeveloper]

do same for description field,

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


Restored from old drupal forum, for user uid:1106 username:guilhermecardoso
You may reset your password to access your new account here.

[guilhermecardoso]

It's fixed now.
Thanks

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[ehcpdeveloper]

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..


Restored from old drupal forum, for user uid:1106 username:guilhermecardoso
You may reset your password to access your new account here.

[georgeb2005]

http://www.ehcp.net/scriptsupdate.sql

"Error/Hata
Page Not Found/Sayfa bulunamadı
Server powered by ehcp"


Some Error Occured.
Error Occured (sourcetablolistele_3_5_4))
err: queryelect 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 ?


Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[ehcpdeveloper]

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.

Restored from old drupal forum, for user uid:3177 username:georgeb2005
You may reset your password to access your new account here.

[georgeb2005]

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

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.