Anti-SOPA/PIPA Campaign
Drupal Camp Manila 2012
Blog 
Joomla Web Development Articles check manual that corresponds to your MySQL server version for right syntax to use near TYPE=MEMORY
Joomla Web Development Articles check manual that corresponds to your MySQL server version for right syntax to use near TYPE=MEMORY
Written by Joomla Web Developer Saturday, 18 February 2012 10:52
Articles - Joomla Web Development Articles
Some errors occurred while populating the database: 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 'TYPE=MEMORY'
The problem could be solved with two alternative ways:
- install stable version of mysql, for example 5.1.52 (add library plugins as necessary for wampserver or xamp)
- replace the TYPE=MEMORY with ENGINE=MEMORY (make a backup copy first, then try a global and replace for example with notepad or any editor)
ACE IT Learning Solutions offers affordable, practical Joomla and Drupal hands-on trainings and courses, as well as SEO / Analytics seminars conducted regularly at the training center in Cubao, Quezon City, Philippines. Visit ACE IT training website to learn more.
SEO company - Increase organic search engine rankings. Increase your sales. Increase your profits. The UK's leading SEO company. Please visit Smart Traffic United Kingdom and SEO Service Australia for more information.
Seminars and workshops are also being offered at TipidPC Events in Ortigas, Pasig City and at Buendia, Makati, Metro Manila, Philippines. Please visit the TPC Events.Org website for more information.
Binary Republic is your online source of computer tutorials on programming, software and computer-related topics on .Net, ASP.net, Database, Java, Linux, Microcontrollers, Open Source, Photoshop, PHP, Tech News, Web Design, Web Development, Wireless technology, among others. Visit the website blog at BinaryRepublic.com.
Joomla Blog Articles and Notes
-
Problem in Joomla 2.5 comments and messaging and mailer for JDContact, K2 Comment, and Contact module (in Contact page), messaging and comments not working/sending I have the following modules and features installed in a website: JDContact, K2 Comment, Contact module (in Contact page), but had been encountering problems in sending messages. Checked the mail settings...
-
Joomla 1.7 update to 2.5 error JInstaller: :Install: Error SQL DB function failed with error When I did Extension Manager > Update from the backend to update a Joomla 1.7 website to Joomla 2.5, the following errors occurred: JInstaller: :Install: Error SQL DB function failed with error number...
-
Best Practices for Joomla Installation/Startups - Joomla 2.5 onwards A simple yet proven and practical list of Joomla best practices, recommended steps and tips for Joomla installation and startups for Joomla version 2.5 and onwards. Backup your website immediately...
-
check manual that corresponds to your MySQL server version for right syntax to use near TYPE=MEMORY Some errors occurred while populating the database: 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 'TYPE=MEMORY'...
-
[SOLVED] Error: the XML response that was returned from the server is invalid, installing Joomla Trying to install a Joomla 1.5.15 version, at step Database, at Install sample data, error appears: The page at localhost says: Error: the XML response that was returned from the server is invalid....
- 1
- 2
- 3
- 4
- 5
- 6
- 7
Drupal Blog Articles and Notes
-
Drupal, Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 54 bytes) Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 54 bytes). Drupal errors on Openpublic distro profile installer: Fatal error: Maximum execution time of xxx seconds...
-
Fatal error: Maximum execution time of 30 seconds exceeded in Joomla, Drupal or any other PHP CMS Fatal error: Maximum execution time of 30 seconds exceeded during installation of Joomla, Drupal or any other PHP-based CMS. The default maximum execution time of each script (in seconds) are normally...
-
Drupal Seminar and Demo, Buendia, Makati, November 2010 Drupal Drupal is one of the best Content Management Systems (CMS). It is written in PHP and requires a MySQL database. Its basic installation can be easily turned into many different types of web sites...
-
Drupal Seminar and Hands-on Demo, TPCEvents.Org, Ortigas, Pasig, Metro Manila Thursday, August 6, 2009 A Drupal 6 Seminar, Ortigas, Pasig... more details at TPCEvents.Org (a TipidPC affiliate) Drupal Seminar (Web Content Management System) Date: Aug 23, 2009 - Sunday Time: 9:00am...
Web / Internet Resources
-
Lorem ipsum text Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation...
-
Hotel Website Benefits, Features and Advantages Business and Corporate Branding / Identity Your hotel business, travel and online booking company will have credibility and business identity with its own official website, readily found on the internet...
-
Opensource CMS seminars to AISAT-Asian Institute of Science And Technology (all branches) We've just conducted a series of opensource CMS seminars to AISAT-Asian Institute of Science And Technology students of Fairview (Quezon City), Dau (Pampanga), Imus (Cavite), and Baliuag (Bulacan). Thanks...
-
How to use domain from an external registrar to point to another domain/website Ever had the need to point one (preferred) domain from another registrant to an existing website (which has another domain registered by another webhost)? Or, say, you simply have to register this...
-
Web developer toolbar in Firefox not showing, displayed, missing and not visible If your installed Firefox add-on Web developer toolbar (icons, text, or both) is suddently not showing, displayed, and has gone missing from your Mozilla FF browser, you may consider the following to...
- 1
- 2
- 3
Latest Comments
- [SOLVED] How to remove / unins...
Thank you. I still had Babylon in my Program Data files according to Spybot so I cleared the file from there as well.
02.05.12 04:58
Posted by: Julie - [SOLVED] How to remove / unins...
76yr old ready to pull my hair out oops, it's gone, so is Babylon..thanks a bunch.
23.04.12 13:16
Posted by: Squiddiddler - [SOLVED] How to remove / unins...
It works! Thanks. ^^
28.03.12 08:25
Posted by: kary - [SOLVED] How to remove / unins...
:D Great advice. NB This Babylone stopped my windows update!!!! Google babylone safe and its not.
05.03.12 09:54
Posted by: Jay - Joomla, Drupal, Wordpress, SEO...
Im interested also for web dev training, please send me details (schedule & price) thanks.
02.03.12 18:37
Posted by: Martin Abanes - [SOLVED] How to remove / unins...
Thanks a ton!
01.03.12 02:56
Posted by: gopal - [SOLVED] How to remove / unins...
finally...had to do it twice but it now gone. especially horrid program
27.02.12 23:31
Posted by: PB - [SOLVED] How to remove / unins...
brilliant...thanks horrid babylon has gone from my computer. invading my computer without my permission! :lol:
27.02.12 23:03
Posted by: PB - [SOLVED] How to remove / unins...
just brilliant. thanks very much. that unwanted horrid babylon is gone from my computer. their invasion of my computer is outrageous!
27.02.12 23:00
Posted by: PB - [SOLVED] How to remove / unins...
It's ok. I fixed the error message. I just disabled all add-ons and the error message stopped. Thanks for the help with Babylon. Awesome that it's gone! Cheers!
20.02.12 21:45
Posted by: J
In Joomla 1.5, this happens after I did the ff:
