X-Cart forums

[Vacman]

Like 2coolbaby, I too would like someone to set this up - cPanel here...

[Kara]

NuAlpha,
I went through the steps, even set up the cron. But found I had misplace my sql pasword, so I changed it. Now I get this error when trying to access my site:

Warning: mysql_connect(): Access denied for user: 'acecase_xuser@web20' (Using password: YES) in /hsphere/local/home/acecase/acecase.com/store/include/func.php on line 44

Warning: mysql_select_db(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /hsphere/local/home/acecase/acecase.com/store/include/func.php on line 48

Warning: mysql_select_db(): A link to the server could not be established in /hsphere/local/home/acecase/acecase.com/store/include/func.php on line 48
Could not connect to SQL db

Help...anyone...

[ranger82nd]

Open config.php get your original password and set it back to that or change the password field in config.php. That should get you going again.

[Kara]

Thank you!

[marcgeldon]

This is really a nice script!

[Lambo]

I'm sorry to bump this thread, but it was the logical place to put this question.

Originally our site was slow, (Even when there was no data on it, and a blank template.)

Once I'd custimized and imported our data I found that the site was still very slow. 10 to 15 seconds sometimes just to flick to different catagories.

I've followed all the recomendations here from the the site below for speeding up X-Cart. All except this one.

http://www.websitecm.com/news/14/Speed-up-your-XCart-Installation.html

If you have say a DB of 3000-4000 products, what kind of impact speed wise can such a script have?

I've followed the instructions and recommendations as mentioned in the thread. I'd prefer to manually do this, and I have been from the absolute path. It appears to be working, but other then a blank page how do I know it's doing anything at all? How long should it take?

[SMDStudios]

Will this work with the 4.1.x branch?

[just wondering]

It should work with any version of ... anything, really, as long as it has a mySQL Database. I wouldn't recommend it on any other type of Database, like msSQL. It does nothing to X-Cart itself, just cleans up the mySQL Database so that it's more organised & works faster.

[AquaMan]

Hi,
Is there a way to tell if this is actually working? (ie ...a test or a report?)

[cautious]

Yes, today I started getting sql_query failure too, as shown by the snap shot below. My email is also full or related notifications

=======================
INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT count(*) FROM xcart_sessions_data WHERE sessid='681572c3424d8ed7f5dbb16c57dda74c'
SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:13:{s:5:\"login\";s:0:\"\";s:11:\"editor_m ode\";s:0:\"\";s:8:\"sns_flag\";s:0:\"\";s:13:\"sn s_do_action\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\"; s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\" \";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\"; s:1:\"Y\";}s:10:\"login_type\";s:0:\"\";s:6:\"logg ed\";s:0:\"\";s:11:\"top_message\";s:0:\"\";s:16:\ "current_language\";s:2:\"US\";s:17:\"merchant_pas sword\";s:0:\"\";}' WHERE sessid='681572c3424d8ed7f5dbb16c57dda74c'
INVALID SQL: 0 :
SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:13:{s:5:\"login\";s:0:\"\";s:11:\"editor_m ode\";s:0:\"\";s:8:\"sns_flag\";s:0:\"\";s:13:\"sn s_do_action\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\"; s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\" \";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\"; s:1:\"Y\";}s:10:\"login_type\";s:0:\"\";s:6:\"logg ed\";s:0:\"\";s:11:\"top_message\";s:0:\"\";s:16:\ "current_language\";s:2:\"US\";s:17:\"merchant_pas sword\";s:0:\"\";}' WHERE sessid='681572c3424d8ed7f5dbb16c57dda74c'
=======================

As a result my site was useless. I researched this on the internet. It appears that many x-cart sites have experienced similar problems at one time or the other. Yes, I agree with balinor and others elsewhere in this forum that it is not x-cart direct problem. Nonetheless, I think x-cart should still research this and supply an integrated solution as part of HA and store maintenance feature.

Here is the solution that eventually worked for me to remedy the problem. It may work for you too. Note that I have a dedicated server so I was able to login and perform these steps manually. I recommend manual operation.

1. First backup you DB. Multiple ways to do this. In my case, I simply stopped mysqld (/etc/init.d/mysqld stop) and then made a zipped tarball of the DB (tar cvzf mysql_bak.tgz mysql ). Then start the DB (/etc/init.d/mysqld start)

2. Review the error(s) with this
mysqlcheck -s -u [Your_db_root_uname] -p[Hispasswd] [TheDBname]

where [text] is what you must supply as your correct value w/o the delimiting square brackets.

3. Then do the repair with this
mysqlcheck -r -q -u [Your_db_root_uname] -p[Hispasswd] [TheDBname]

4. Hopefully the above fixes all the problem as evident by the OK's it spits out. Just to be sure, repeat Step 2 to verify all the errors are gone:
mysqlcheck -s -u [Your_db_root_uname] -p[Hispasswd] [TheDBname]

If all is well, the last command should just return a prompt. If not, if you still have errors, you may need a professional to step in.

Cheers