Totally Stuck now - newby to oscommerce

[sham200872]

Hi All

 

1. price displayed is 0 for all products

 

2. In admin when going to Localization this appears:

 

"Currencies

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

 

select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, last_updated, value from currencies order by title limit -6, 6

 

[TEP STOP]"

 

Any help greatful

[♥geoffreywalton]

Steve

 

Try posts 15 & 27 in the first thread in the installation forum (the number coulos be wrong)

 

Also there is a patch available for the same type of error which can be found by ollowing the link in my signature block.

 

G

 

If you get stuck again try these resources

 

The documentation that comes with the download of the latest version of osc or download a copy

 

Then read the knowledgebase or download a copy

 

http://www.oscommerce.com/solutions/documentation

 

A roadmap for newbies by lindsayanng.

 

http://www.oscommerce.com/forums/index.php?sho...=307356&hl=

 

Also read the first 2 threads in the installation forum.

 

http://www.oscommerce.com/forums/index.php?showforum=1

 

Try these 2

 

http://www.oscommerce.com/forums/index.php?sho...307356&st=0

 

http://www.oscommerce.com/forums/index.php?sho...p;#entry1366452

 

Finally use the search term

 

site:www.oscommerce.com/forums xxxxxxxxxxxxxxx

 

in google whenever you get stuck.

[sham200872]

Geoff

 

Do you know anyone that fixes this stuff as I am at the end of my wits now..............

 

I am willing to let someone get into server fix issues and install protx form payment