Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
X-Cart Home FAQ Forum rules Calendar User manuals Login  

Noticed MYSQL issue anyone help

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 08-29-2009, 07:13 PM
 
mrerotic mrerotic is offline
 

eXpert
   
Join Date: Feb 2009
Posts: 264
 
Default Noticed MYSQL issue anyone help
I have the following error showing in mysql for xcart_categories I havent changed anything here does anyone else have any ideas on this?

Thanks
Attached Thumbnails
Click image for larger version Name: xcart_categories.jpg Views: 172 Size: 95.9 KB ID: 1645  
__________________
x-cart 4.2.3
AlteredCart Smart Search
Auto Featured Products Mod (Personal Mod)
BCSE Product Importer Pro & Drop Shipper Pro
CDSEO Pro
CMS EZRecommends
EE slider login (Personal Mod)
Next Prev Link Mod (Customized)
ShadowBox Detailed Images (Personal Mod)
Shop By Price (Customized)
Social Media (Personal Mod)
Switch Layout View (Personal Mod)
Special Offers
Testimonials (Personal Mod)
Whats New (Customized)
Reply With Quote
  #2  
Old 08-29-2009, 08:22 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
   
Join Date: Apr 2007
Posts: 14,201
 
Default Re: Noticed MYSQL issue anyone help
It is save to delete the second one. Actually there was one more table with duplicate index but could be fixed in your version
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #3  
Old 08-29-2009, 08:57 PM
 
mrerotic mrerotic is offline
 

eXpert
   
Join Date: Feb 2009
Posts: 264
 
Default Re: Noticed MYSQL issue anyone help
Yea well tried to remove "am" gave errors in admin area. That is not safe to remove.
__________________
x-cart 4.2.3
AlteredCart Smart Search
Auto Featured Products Mod (Personal Mod)
BCSE Product Importer Pro & Drop Shipper Pro
CDSEO Pro
CMS EZRecommends
EE slider login (Personal Mod)
Next Prev Link Mod (Customized)
ShadowBox Detailed Images (Personal Mod)
Shop By Price (Customized)
Social Media (Personal Mod)
Switch Layout View (Personal Mod)
Special Offers
Testimonials (Personal Mod)
Whats New (Customized)
Reply With Quote
  #4  
Old 08-30-2009, 05:48 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
   
Join Date: Apr 2007
Posts: 14,201
 
Default Re: Noticed MYSQL issue anyone help
I was answering to you yesterday by memory (I guess my memory is not very good yet )
I saw this few months ago and asked QT here is what they told me
HTML Code:
Thank you for the report.
It is safe to remove the 'avail' index. 


--
Sincerely yours,
Eugene Kaznacheev,
Head of Technical Support Department
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #5  
Old 08-31-2009, 02:21 PM
 
mrerotic mrerotic is offline
 

eXpert
   
Join Date: Feb 2009
Posts: 264
 
Default Re: Noticed MYSQL issue anyone help
Thanks CFL doesnt look like that gave me any errors.
__________________
x-cart 4.2.3
AlteredCart Smart Search
Auto Featured Products Mod (Personal Mod)
BCSE Product Importer Pro & Drop Shipper Pro
CDSEO Pro
CMS EZRecommends
EE slider login (Personal Mod)
Next Prev Link Mod (Customized)
ShadowBox Detailed Images (Personal Mod)
Shop By Price (Customized)
Social Media (Personal Mod)
Switch Layout View (Personal Mod)
Special Offers
Testimonials (Personal Mod)
Whats New (Customized)
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design

« Previous Thread | Next Thread »


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:22 PM.

   
 
X-Cart forums © 2001-2020