X-Cart forums

[TonyD]

Hi

I am using X-Cart DB Version: 4.7.3 GOLD.
In my shop Product images src is like "image.php?type=P&id=XXXX". i hope by default it is like that.

Let me know whether it is possible to have the imagefilename displayed . Eg:images/P/filename.jpg

Looking forward for your advice!

[cflsystems]

Are images in database? Move them to file system - admin -> settings -> images location

[TonyD]

There has been a developer working on the cart and there is an error when trying to use the built in functions of changing the images location..

INVALID SQL: 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 'WHERE id=1 LIMIT 1' at line 1
SQL QUERY FAILURE:SELECT image_x, image_y, image_path FROM WHERE id=1 LIMIT 1
Backtrace:

file: 610 - /var/www/vhosts/mysite.com/staging2/include/func/func.db.php
call: func_get_backtrace_html()

file: 971 - /var/www/vhosts/mysite.com/staging2/include/func/func.db.php
call: db_query("SELECT image_x, image_y, image_path FROM WHERE id=1 LIMIT 1")

file: 4 - /var/www/vhosts/mysite.com/staging2/modules/TXS_Fashion_Walk/logo.php
call: func_query_first()

file: 30 - /var/www/vhosts/mysite.com/staging2/modules/TXS_Fashion_Walk/init.php
call: unknown()

file: 9 - /var/www/vhosts/mysite.com/staging2/modules/TXS_Fashion_Walk/config.php
call: unknown()

file: 1065 - /var/www/vhosts/mysite.com/staging2/init.php
call: include("/var/www/vhosts/mysite.com/staging2/modules/TXS_Fashion_Walk/config.php")

file: 53 - /var/www/vhosts/mysite.com/staging2/admin/auth.php
call: require_once("/var/www/vhosts/mysite.com/staging2/init.php")

file: 44 - /var/www/vhosts/mysite.com/staging2/admin/images_location.php
call: require("/var/www/vhosts/mysite.com/staging2/admin/auth.php")

[cflsystems]

SQL QUERY FAILURE:SELECT image_x, image_y, image_path FROM WHERE id=1 LIMIT 1

is missing table. It should be

....FROM TABLE_NAME WHERE....

[TonyD]

Do you know from where the call is being initiated for the above query?

[cflsystems]

look at the Backtrace within the error