Community Forums

by **pagetopixel** » Sat Oct 08, 2011 6:37 am

Hello,

I ran the upgrade script after doing up to step 10. I am now getting these errors

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 63

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 63

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 63

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 63

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 63

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 63

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ghindman/new.knckids.com/install/model/upgrade.php on line 54
Could not Execute: ALTER TABLE option_value ADD image varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin AFTER option_id;
Table 'oc_knckids.option_value' doesn't exist

Can someone point me in the right direction? Q if you are willing to help me get setup and debug I will gladly give a donation. Thanks!

by **Qphoria** » Sat Oct 08, 2011 1:13 pm

Seems like you missed a few steps. Did you run the 1.4.x to 1.5.x Beta2 script first?

by **pagetopixel** » Sat Oct 08, 2011 4:39 pm

Qphoria wrote:Seems like you missed a few steps. Did you run the 1.4.x to 1.5.x Beta2 script first?

Hey, thanks for the reply. I uploaded the new files and my old config files. I then made the additions to the config file and then ran the script. Thanks!

by **Qphoria** » Sat Oct 08, 2011 7:24 pm

ok. so you ran the beta2 script first, and then ran the 1.5.1.3 built in upgrade script as noted at the bottom of the first post: viewtopic.php?f=2&t=36519 ??

by **pagetopixel** » Sat Oct 08, 2011 11:31 pm

Qphoria wrote:ok. so you ran the beta2 script first, and then ran the 1.5.1.3 built in upgrade script as noted at the bottom of the first post: viewtopic.php?f=2&t=36519 ??

Ahhh you are exactly right it was the order. Thanks for that. Everything is working great now except for when I go to the dashboard I get this error at the top.

Warning: fopen(/home/new.knckids.com/download/test) [function.fopen]: failed to open stream: No such file or directory in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 99Warning: fclose(): supplied argument is not a valid stream resource in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 103Warning: sprintf() [function.sprintf]: Too few arguments in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 106

by **Qphoria** » Sun Oct 09, 2011 2:27 am

pagetopixel wrote:Warning: fopen(/home/new.knckids.com/download/test) [function.fopen]: failed to open stream: No such file or directory in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 99Warning: fclose(): supplied argument is not a valid stream resource in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 103Warning: sprintf() [function.sprintf]: Too few arguments in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 106

That is strange.
Not sure why it is looking for a "download/test" folder as that isn't a folder that opencart uses
Either way, the error looks like it can't open the folder. Perhaps you need to add it for a custom mod, or set the write permissions on it

THe second one appears to be a language related issue. the sprintf is a php function that tries to fill in a sentence with a matching number of variables. If the count is mismatched, this error shows.

by **pagetopixel** » Sun Oct 09, 2011 3:24 am

Qphoria wrote:
pagetopixel wrote:Warning: fopen(/home/new.knckids.com/download/test) [function.fopen]: failed to open stream: No such file or directory in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 99Warning: fclose(): supplied argument is not a valid stream resource in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 103Warning: sprintf() [function.sprintf]: Too few arguments in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 106

That is strange.
Not sure why it is looking for a "download/test" folder as that isn't a folder that opencart uses
Either way, the error looks like it can't open the folder. Perhaps you need to add it for a custom mod, or set the write permissions on it

THe second one appears to be a language related issue. the sprintf is a php function that tries to fill in a sentence with a matching number of variables. If the count is mismatched, this error shows.

I added a folder called test to the download folder and the error is still there. It must be an old module, I will go trough it and see if i can fiure it out. As for the language issue any idea how to fix that?

by **pagetopixel** » Sun Oct 09, 2011 4:30 am

To rule out the modules I setup a fresh install an tranferred over the config files and upated the paths. The errors are still there...

Warning: fopen(/home/newest.knckids.com/download/test) [function.fopen]: failed to open stream: No such file or directory in /home/ghindman/newest.knckids.com/admin/controller/common/home.php on line 99Warning: fclose(): supplied argument is not a valid stream resource in /home/ghindman/newest.knckids.com/admin/controller/common/home.php on line 103Warning: sprintf() [function.sprintf]: Too few arguments in /home/ghindman/newest.knckids.com/admin/controller/common/home.php on line 106

by **pagetopixel** » Tue Oct 11, 2011 5:57 am

Qphoria wrote:
pagetopixel wrote:Warning: fopen(/home/new.knckids.com/download/test) [function.fopen]: failed to open stream: No such file or directory in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 99Warning: fclose(): supplied argument is not a valid stream resource in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 103Warning: sprintf() [function.sprintf]: Too few arguments in /home/ghindman/new.knckids.com/admin/controller/common/home.php on line 106

That is strange.
Not sure why it is looking for a "download/test" folder as that isn't a folder that opencart uses
Either way, the error looks like it can't open the folder. Perhaps you need to add it for a custom mod, or set the write permissions on it

THe second one appears to be a language related issue. the sprintf is a php function that tries to fill in a sentence with a matching number of variables. If the count is mismatched, this error shows.

Any other ideas?

by **a2z** » Tue May 15, 2012 1:07 pm

Sorry to post on an old post. But I am having the exact same error. I copied my production database and restored it into a freshly installed sandbox. I copied all the file system as required. I see the error only on dashboard. everything else seems to be working fine.