Xcart Image display
 

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!

Re: Xcart Image display
 

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

Re: Xcart Image display
 

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")

Re: Xcart Image display
 

is missing table. It should be

....FROM TABLE_NAME WHERE....

Re: Xcart Image display
 

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

Re: Xcart Image display
 

look at the Backtrace within the error