Where is the Ajax Image Swapper database?
Printable View
Where is the Ajax Image Swapper database?
AIS installs its MySQL data into the existing configuration and configuration_group tables of your database.
I just did a fresh install on a 1.39h version. I have installed a few mods IH2 fual slimbox, additional image relocated with css, mailbeez.
The set up image and clean now buttons do not seem to work. The catagories and products show and when I try adding an image I get.
1054 Unknown column 'products_id_no_attribute' in 'field list'
in:
[INSERT INTO zen_products_attributes_images (image_id, products_attributes_id, products_id_no_attribute, image_path, image_title, image_sort_order) VALUES ( NULL, '0', '5', 'images/Ebony_mac_regular_kleenex_01.jpg', 'Ebony_mac_regular_kleenex_01.jpg', 0)]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
The cart shows the images on the category page but the product page shows a frame with the orbit image.
site is http.//www.tissue-box-covers.com/
Thanks
Did you install the sql file through your admin panel or some other way?
Looks like your database uses the zen_ prefix and the installer file doesn't. Using Install SQL Patches will adjust for that.
I have tried installing through the admin using both the paste and the upload. I had fual slim box installed it produced a duplicate error so I used the fual sql unistalled and tried installthe ajax sql again I get
1062 Duplicate entry 'IMAGE_VIEWER_SMALL_IMAGE_HEIGHT' for key 'unq_config_key_zen'
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('', 'Small Image Height', 'IMAGE_VIEWER_SMALL_IMAGE_HEIGHT','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 1, now()), ('', 'Small Image Width', 'IMAGE_VIEWER_SMALL_IMAGE_WIDTH','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 5, now()), ('', 'Medium Image Height', 'IMAGE_VIEWER_MEDIUM_IMAGE_HEIGHT','300','The height of medium images in AJAX Image Swapper. Default 300.', @last_id, 10, now()), ('', 'Medium Image Width', 'IMAGE_VIEWER_MEDIUM_IMAGE_WIDTH','300','The width of medium images in AJAX Image Swapper. Default 300.', @last_id, 15, now()), ('', 'Large Image Height (Max. image height)', 'IMAGE_VIEWER_LARGE_IMAGE_HEIGHT','9999','The height of large images / maximum image height in AJAX Image Swapper.', @last_id, 16, now()), ('', 'Large Image Width (Max. image width)', 'IMAGE_VIEWER_LARGE_IMAGE_WIDTH','9999','The width of large images / maximum image width in AJAX Image Swapper.', @last_id, 17, now()), ('', 'Number of Images Shown', 'IMAGE_VIEWER_IMAGES_NUM','3','Number of images shown in AJAX Image Swapper', @last_id, 20, now()), ('', 'Scroll Size', 'IMAGE_VIEWER_SCROLL_SIZE','3','How many images to be scrolled when pressing left or right arrow', @last_id, 25, now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Thanks
My DB does use the zen_ prefix
Thanks
You would have been better served to make a backup of the database before the installation and revert to the backup if there were problems.
You still seem to be confusing the database by mixing code with and without the zen_ prefix.
Do you have phpMyAdmin with your hosting package?
Yes I do have phpMyAdmin. my host is bluehost.
Thanks
Can someone give the steps to maually configure the DB.
Thanks
RJ
I guess with all the mods on my site and the issue with my db zen prefix it maybe time to just give up on this working. to bad because it could be a nice feature.
I restored my store with my backup but I need to remove three ajax swapper links in admin/configuration and several fual slimbox.
Could someone point me in the right direction
Thanks