MySQL error in shop, not in admin section - Webmaster Forums UK SEO SEM Webmaster Community Forum

DJ-Loki · #1 (**permalink**) 06-30-2003, 11:54 PM

Hello,

I have just installed IG-Shop, but there is a problem. The admin section works fine, but there are problems with the shop section.

I have this error:

Code:

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/djloki.com/httpdocs/store/page.php on line 323 Error: Page Not Found

What can be the problem?

Regards,

Loki

http://www.dj-loki.com/store/

DJ-Loki · #2 (**permalink**) 07-01-2003, 05:43 PM

Could i get some support on this on please? :cry:

temi · #3 (**permalink**) 07-01-2003, 10:27 PM

Ummm,
What browser are you using? What, server, httpd daemon are you running iG Shop on?. You need to have cookies enabled, you should also use Internet explorer 6 or Netscape 7.
Thanks

DJ-Loki · #4 (**permalink**) 07-02-2003, 12:00 AM

I tried it with IE 6 and Opera 7.11. The server has: PHP VERSION: 4.1.2, MySQL VERSION: 3.23.56, and it is a Redhat Linux server. But i do not think it is a hardware problem, but a communication problem between the files and the database.....

DJ-Loki · #5 (**permalink**) 07-02-2003, 03:16 AM

This is the part at line 323:

Code:

$usr_res=mysql_query($qry_txt);
if (mysql_num_rows($usr_res)>0)

#6 (**permalink**) 07-05-2003, 03:15 PM

Please add this record to users table :

INSERT INTO users VALUES (3, 'demo', 'test', 'test@demo.com', 'e2483d2325dcf44617f9d0e92fad70f4', 'Mr', 'city 5', 'demos', 'test', '03700', 'demo', '+40788342885', 'test', 'demo', 'test', '03700', 'demo', '+40788342885');

zylair69 · #7 (**permalink**) 07-08-2003, 05:51 PM

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home3/zylair69/public_html/ig_shop/ig_shop/page.php on line 323
Error: Page Not Found
I just installed and have same problem. Netscape 7.1, IE 6, same result.
http://cgi-bin.spaceports.com/~zylair69/
I'm not to good at programming, so any help would be great. Thanks.
I use Dreamweaver MX, not sure what server is using as far as php, mySQL or other, but I installed a phpBB there and that is working fine.
Can login to admin side, but seems there are problems there also, will get back to you with more info. It's probably things I did wrong as I have little php knowledge, I'm just starting out with php.

zylair69 · #8 (**permalink**) 07-08-2003, 06:01 PM

Quote:

Originally Posted by misi

Please add this record to users table :

INSERT INTO users VALUES (3, 'demo', 'test', 'test@demo.com', 'e2483d2325dcf44617f9d0e92fad70f4', 'Mr', 'city 5', 'demos', 'test', '03700', 'demo', '+40788342885', 'test', 'demo', 'test', '03700', 'demo', '+40788342885');

Not sure where to put this, can I do it using my Dreamweaver, and just copy and paste where it belongs?

#9 (**permalink**) 07-12-2003, 05:50 PM

No, the sample way is to use PhpMyadmin and run this query.