Script problem!

Find all the help you need on the script Arfooo Directory.
Please refer any bugs found.

Moderator: effi

Script problem!

Postby Netscype » Wed May 21, 2008 7:05 am

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
Netscype
 
Posts: 26
Joined: Wed Apr 02, 2008 10:23 am

Re: Script problem!

Postby Arf » Wed May 21, 2008 7:43 am

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.
Arf
Site Admin
 
Posts: 212
Joined: Fri Mar 14, 2008 6:51 pm

Re: Script problem!

Postby Netscype » Wed May 21, 2008 2:37 pm

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
Netscype
 
Posts: 26
Joined: Wed Apr 02, 2008 10:23 am

Re: Script problem!

Postby Arf » Wed May 21, 2008 3:19 pm

Hi,
Ok, now all works fine sure ?

Arf.
Arf
Site Admin
 
Posts: 212
Joined: Fri Mar 14, 2008 6:51 pm


Return to Installation, support and bug reports

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 0 guests

 
Copyright © arfooo.net  2007 - 2010  -  All rights reserved.
Arfooo website group: petites annonces gratuites   voyance en direct - tirage tarot   Consultant en référencement
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group | phpBB SEO
cron