News:

Support the VirtueMart project and become a member

Main Menu

VirtueMart 2.9.4 AIO install SQL error

Started by w2kr, May 21, 2014, 00:53:38 AM

Previous topic - Next topic

w2kr

Hi
I have already got the 2.9.3 installed without issues Running Joomla 3.2.4 then upgraded Joomla to  3.3 and tried to install VM 2.9.4
Main package installed correctly but the AIO gives this error
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 'extension_id=10081' at line 1 SQL=INSERT INTO om3he_update_sites_extensions SET update_site_id=10 extension_id=10081

Other details
PHP 5.3.27
SQL 5.5.36-cll


vbarriof

 Exact same problem.   Migrating from 2.9.3 to 2.9.4 I get the same message installing AIO.



Other details
PHP 5.4.26
mySQL 5.5.37



Milbo

did you try the later uploaded version?

com_virtuemart.2.9.4_extract_first.zip   21.05.2014 14:19
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

olejenya

Quote from: Milbo on May 21, 2014, 18:30:52 PM
did you try the later uploaded version?

com_virtuemart.2.9.4_extract_first.zip   21.05.2014 14:19

now established. The truth components when you come, then an error is displayed

Knowledgekeeper

Hi,

I have also noticed an AIO install SQL error, which seems to be related to using a non-stock template. The copy of Joomla I'm using is a brand new install of Joomla V3.3.0, with the only additions being Virtuemart 2.9.4 and an unmodified SiteGround template. If I use one of the stock templates I get no errors upon loading the front-end, however as soon as I switch to the SiteGround template I get an SQL Error "1064 - You have an error in your SQL syntax;", which can be viewed at http://allbookbindery.com/websites/tkktestsite

My server is running the following, if it helps:
- PHP V5.4.28
- MySQL V5.1.68-cll

I am looking at using Virtuemart for at least four new sites I'm working on, which will all be running Joomla V3.3.0 so a solution or fix would be greatly appreciated.
Six months ago I said I'd never do web development again. So much for that, hahaha!

zbig

I have exactly the same problem...
The second problem is the message on the side and backend:
"Exception in loadConfig for unserialize TinyMCE_jform_articletext_size s:14:"cw
To avoid this message, enter your virtuemart config and just save it one time
Exception in loadConfig for unserialize TinyMCE_product_desc_size s:14:"cw
To avoid this message, enter your virtuemart config and just save it one time"

Milbo

Select a vendor currency and the "accepted currencies"
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Knowledgekeeper

Hi Milbo,

Upon setting the vendor currency and accepted currencies, I get the following errors when saving the configuration:

Invalid field:  First Name

Invalid field:  Last Name

Invalid field:  Address 1

Invalid field:  Zip / Postal Code

Invalid field:  City

Invalid field:

Note that I didn't have these errors when saving the configuration previously.
Six months ago I said I'd never do web development again. So much for that, hahaha!

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Knowledgekeeper

Thanks Milbo, just wondering when is the best time (your time) to Skype you?
Six months ago I said I'd never do web development again. So much for that, hahaha!

w2kr

Have just loaded 2.9.6 with better results so all good on the install but issues with paypal payment system not working so start another thread on that.