Script problem!

[Netscype]

Hi Arf,

I did the install the new script.
When i click on new websites - top rated etc i get this kind of errors:

SELECT siteId, url, imageSrc, siteTitle, description, visitsCount, countryCode, ADDDATE(creationDate, 2) > NOW() as isNew FROM Arfooo_sites WHERE visitsCount > '0' AND status = 'validated' ORDER BY visitsCount DESC LIMIT 20 (1024) B³±d SQL Unknown column 'countryCode' in 'field list' (1054) Database.php line 221 21-5-08 12:01
FrontController->dispatch() # line 13, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/index.php
call_user_func_array(Array[2], Array[0]) # line 329, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/FrontController.php
SiteController->topHitsAction() # line 0, file: unknown
SiteModel->getValidatedTopVisitedSites() # line 139, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/controllers/SiteController.php
SiteModel->selectWithNewFlag(Object:Criteria, "siteId, url, imageSrc, siteTitle, description, visitsCount, coun...") # line 168, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/models/SiteModel.php
Model->findAll(Object:Criteria, "siteId, url, imageSrc, siteTitle, description, visitsCount, coun...", true) # line 65, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/models/SiteModel.php
Database->sqlGetAll("SELECT siteId, url, imageSrc, siteTitle, description, visitsCoun...") # line 130, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/Model.php
Database->sqlQuery("SELECT siteId, url, imageSrc, siteTitle, description, visitsCoun...") # line 324, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/Database.php
trigger_error("B³±d SQL Unknown column 'countryCode' in 'field list' (1054)") # line 221, file: /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/Database.php




Warning: fopen(/var/www/vhosts/netscype.com/subdomains/dir/httpdocs/error.html) [function.fopen]: failed to open stream: Permission denied in /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/ErrorHandler.php on line 81

Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/ErrorHandler.php on line 82

Warning: fclose(): supplied argument is not a valid stream resource in /var/www/vhosts/netscype.com/subdomains/dir/httpdocs/core/ErrorHandler.php on line 83

Netscype Gino

[Arf]

Hi,

Did you do the updating of the database by clicking on the file install/update/update103.php?
It seems that not.

Then we have to remove the contents of the dossier compiled and cache except .htaccess

Arf.

[Netscype]

Hi,

Upgrade did not work same problem.

What i did:
1 backup old database.
2 Removed the tables from the database.
3 removed the old script.
4 installed the new script.
5 removed new tables from the database.
6 installed back the old database backup.
7 did the install/update/update103.php
8 removede the install folder

Works fine !

Netscype Gino

[Arf]

Hi,
Ok, now all works fine sure ?

Arf.