Eventlist Error 1064
Contents |
your password? Forgot your username? ForumSupportJoomla SupportSQL error installing eventlist 1.0.1 TOPIC: SQL error installing eventlist 1.0.1 SQL error installing eventlist error 1064 (42000): you have an error in your sql syntax; 1.0.1 4 years 9 months ago #35683 kmcgeoug OFFLINE Posts: 4 1064 mysql Hi there; I'm a Joomla newbie (and to website design in any form). I'm in Session 30
Mysql Error 1064 (42000)
(Joomla 1.5), in which I supposed to install Eventlist. I've installed Eventlist 1.0.1, the stable version of Eventlist for Joomla 1.5, and the module and plug-in installed just
#1064 - You Have An Error In Your Sql Syntax
fine. The component portion installation, however, resulted in the error message below. I'm not experienced in SQL at all, so don't know how to implement this fix. Please help! JInstaller::install: SQL Error. DB function failed with error number 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server you have an error in your sql syntax check the manual that corresponds to your mysql server version version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 29 SQL=CREATE TABLE IF NOT EXISTS `jos_eventlist_events` ( `id` int(11) unsigned NOT NULL auto_increment, `locid` int(11) unsigned NOT NULL default '0', `catsid` int(11) unsigned NOT NULL default '0', `dates` date NOT NULL default '0000-00-00', `enddates` date NULL default NULL, `times` time NULL default NULL, `endtimes` time NULL default NULL, `title` varchar(100) NOT NULL default '', `alias` varchar(100) NOT NULL default '', `created_by` int(11) unsigned NOT NULL default '0', `modified` datetime NOT NULL, `modified_by` int(11) unsigned NOT NULL default '0', `author_ip` varchar(15) NOT NULL default '', `created` datetime NOT NULL, `datdescription` mediumtext NOT NULL, `meta_keywords` varchar(200) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `recurrence_number` int(2) NOT NULL default '0', `recurrence_type` int(2) NOT NULL default '0', `recurrence_counter` date NOT NULL default '0000-00-00', `datimage` varchar(100) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `registra` tinyint(1) NOT NULL default '0', `unregistra` tinyint(1)
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET US
Error 1064 Mysql 42000 Mysqldump
ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING CONTACT error 1064 mysql 42000 create table US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated Hosting Reseller Hosting check the manual that corresponds to your mysql server version for the right syntax to use near KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question User Submitted Articles Education Channels Android BoldGrid cPanel DokuWiki Drupal https://www.ostraining.com/support-forum/joomla-support/sql-error-installing-eventlist-101/ 7 Drupal 8 Everything Email Joomla 2.5 Joomla 3.1 K2 Magento 1.6 Mambo MediaWiki Moodle Movable Type OpenCart OpenCart 2.0 osCommerce PHP-Fusion PHP-Nuke phpBB phpList Premium Website Builder PrestaShop 1.5 PrestaShop 1.6 SMF Tiki Wiki VirtueMart 3 Web Hosting Manager Website Design WordPress Tools & Resources Email http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 Configuration Blacklist Check Visual DNS Lookup Quick Tagger Icon Sets Favicon Generator Bounce Back Parser What is my IP address? >>Website .htaccess (17)Adobe Flash (2)APIs (2)Backup and Restore (15)Billing (8)Browser Issues (2)Connecting to a Database (5)cPanel (26)cPanel Account Management (16)Cron Jobs (4)Cube Cart (2)Database Setup (5)Database Troubleshooting (6)Domain Management (2)Dreamweaver (12)Drush (2)eCommerce (7)Elasticsearch (4)Fantastico (4)File Management (16)File Manager (6)FTP (10)FTP Client Setup (21)General Server Setup / Management (15)Getting Started Guides (18)Ghost (3)Google Tools (21)How To (23)HTML (2)Image Editing (2)IP Addresses (3)iWeb (1)JavaScript (2)Joomla (10)Joomla 2.5 (36)Koken (11)Linux (27)Logaholic (5)Magento (2)Maintaining Your Website (1)Managing Files (7)Microsoft FrontPage (11)Microsoft Publisher (1)ModSecurity (7) MODx (3)New Customers (7)Open Classifieds (1)PCI Compliance (7)PHP (15)PHP Configuration (7)PHP Troubleshooting (6)phpBB (25)phpMyAdmin (10)Premium Website Builder (22)Prestashop (1)Protecting Files (5)Publishing Your Site (2)Python (1)Redirects (4)Restricting Bots (5)Search Engine Optimization (1)Secure Socket Layer (SSL) Tutorials (13)Security (12)Sending Email From
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting http://stackoverflow.com/questions/9680349/error-1064-in-mysql ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error #1064 in mysql [duplicate] up vote 6 down vote favorite 1 This question already has an answer here: 1064 error in CREATE TABLE … TYPE=MYISAM 2 answers I keep getting this error: 1064 - You have an error 1064 error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=58' at line 11 This is my query : CREATE TABLE `tbl_cart` ( `ct_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `pd_id` int( 10 ) unsigned NOT NULL default '0', `ct_qty` mediumint( 8 ) unsigned NOT NULL default '1', `ct_session_id` char( 32 ) NOT NULL default '', `ct_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( `ct_id` you have an ) , KEY `pd_id` ( `pd_id` ) , KEY `ct_session_id` ( `ct_session_id` ) ) TYPE = MYISAM AUTO_INCREMENT =58; Help Me What the problem is ... mysql share|improve this question edited Mar 29 '15 at 8:31 NiMa Derakhshan Jan 1,04261225 asked Mar 13 '12 at 8:09 Peyman Omidi 49116 marked as duplicate by PeeHaa, Tyler Crompton, Ocramius, hakre, Sajmon Apr 8 '13 at 22:29 This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question. add a comment| 2 Answers 2 active oldest votes up vote 24 down vote The keyword TYPE is removed since MySQL 5.1, use ) ENGINE = MYISAM AUTO_INCREMENT =58; instead. share|improve this answer answered Mar 13 '12 at 8:14 Joachim Isaksson 116k11134170 add a comment| up vote 0 down vote CREATE TABLE `tbl_cart` ( `ct_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `pd_id` int( 10 ) unsigned NOT NULL default '0', `ct_qty` mediumint( 8 ) unsigned NOT NULL default '1', `ct_session_id` char( 32 ) NOT NULL default '', `ct_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( `ct_id` ) , KEY `pd_id` ( `pd_id` ) , KEY `ct_session_id` ( `ct_session_id` ) ) ENGINE = MYISAM AUTO_INCREMENT =58; share|improve this answer answered Mar 13 '12 at 8:14 juergen d 126k21131196 maybe a little explanation would have been useful... –oezi Mar 13 '12 at 8:15 add a comment| Not the answer you're looking f