Some errors with my site.

[dameon]

My site.

http://motionebooks.com

 

 

The errors:

 

1. [Front Side] At http://motionebooks.com on the left side there are 2 images. One talking about 1,000 ebooks, the other talking about 30,000 ebooks. They are linked to a product ID that is not the ID I want them to be linked to. I have looked through my MySQL Database and many of my PHP files and have not been able to find out how to change this product ID.

 

2. [Admin Side] At http://motionebooks.com/admin errors:

A. http://www.motionebooks.com/admin/specials.php = MYSQL error.

B. http://www.motionebooks.com/admin/products_expected.php = MYSQL Error.

C. http://www.motionebooks.com/admin/reviews.php = MYSQL Error.

D. http://www.motionebooks.com/admin/manufacturers.php = MYSQL Error.

E. http://www.motionebooks.com/admin/stats_customers.php = MYSQL Error.

F. http://www.motionebooks.com/admin/stats_pr...s_purchased.php = MYSQL Error.

G. http://www.motionebooks.com/admin/orders.php = MYSQL Error.

H. http://www.motionebooks.com/admin/banner_manager.php = MYSQL Error.

I. http://www.motionebooks.com/admin/newsletters.php = MYSQL Error.

That's about it for the admin MySQL errors. I suspect they are all [or mostly] linked together, but I am not good with fixing MySQL errors.

 

All of the MYSQL errors start with:

1064 - 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 '-20, 20' at line 1

 

Help please?

[dameon]

Just so everyone knows, I fixed the MYSQL errors. Still no clue about the first problem.

1. [Front Side] At http://motionebooks.com on the left side there are 2 images. One talking about 1,000 ebooks, the other talking about 30,000 ebooks. They are linked to a product ID that is not the ID I want them to be linked to. I have looked through my MySQL Database and many of my PHP files and have not been able to find out how to change this product ID.

Please help. Thanks ^^

[jonquil]

Just so everyone knows, I fixed the MYSQL errors. Still no clue about the first problem.

 

Please help. Thanks ^^

 

What is the correct ID for 30,000 ?

What is the correct ID for 1,000 ?

[dameon]

What is the correct ID for 30,000 ?

What is the correct ID for 1,000 ?

1000 ebooks = 67

30000 ebooks = 66

[jonquil]

Okay, so the links for these images are hard coded, yes?

 

1000 ebooks = 67 (m22.jpg)

30000 ebooks = 66 (m21.jpg)

[dameon]

Yes

[jonquil]

In what file are they hard coded?

[dameon]

In what file are they hard coded?

That's the problem, I don't know =/

[jonquil]

Assuming you have this entire site resident on your local drive, do a search (using a Text Editor "Find in Files") for one of the image names. Alternatively, look in a file that contains the left column info.

[dameon]

Assuming you have this entire site resident on your local drive, do a search (using a Text Editor "Find in Files") for one of the image names. Alternatively, look in a file that contains the left column info.

I have the files on my hard drive. How do I search multiple files at once?

[jonquil]

Many will have different suggestions. TextPad.com for TextPad. Once you install it, open the application.

 

Search >> Find in Files >> browse to the store folder, key in what you're searching for.

 

That's about as bouncing ball as I can get without drinking your java for ya :)

[dameon]

Thanks a bunch! I found it, it was in /includes/header.php

 

EDIT: New error... when I add a product through categories [even if it's not in any categories] it doesn't show a product id in the link to the product. Look:

http://motionebooks.com

try clicking on a product. No ID... help!

[dameon]

UPDATE: Appears that product IDs only don't show up on the front page. Any help?