Joomla Indonesia

Login or Sign Up
Sign In or Register
Avatar
Not Registered Yet?

Join Now! It's FREE. Get full access and benefit from this site

Reset My password - Remind Me My username

Username
Password
Remember me
  • Page:
  • 1

TOPIC: [HELP] MySQL error

[HELP] MySQL error 8 years 8 months ago #169345

  • msyahril88
  • msyahril88's Avatar
  • OFFLINE
  • Warga Joomla
  • Posts: 4
  • Karma: 0
to the poin aja all

Error

SQL query:

--
-- Database: `stihamsir_db`
--
--
--
-- Table structure for table `o259t_usergroups`
--
CREATE TABLE IF NOT EXISTS `o259t_usergroups` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` int( 10 ) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
`lft` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`title` varchar( 100 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `idx_usergroup_parent_title_lookup` ( `parent_id` , `title` ) ,
KEY `idx_usergroup_title_lookup` ( `title` ) ,
KEY `idx_usergroup_adjacency_lookup` ( `parent_id` ) ,
KEY `idx_usergroup_nested_set_lookup` ( `lft` , `rgt` ) USING BTREE
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =9;

MySQL said: Documentation
#1064 - 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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9' at line 18

pesan itu muncul pada saat sy import database dr localhost ke web hosting, pdhl pada saat ekspor g ada pesan error muncul (di localhost). sy pake Joomla_1.7.2-Stable-Full_Package

di localhost terdapat 34 tables waktu import ke web hosting tinggal 28 tables

mohon kepada master ato tmn joomla lover tuk sharing atau memberikan jawabn atas permasalahan di atas.

Terima Kasi
Last Edit: 8 years 8 months ago by msyahril88.
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 0.062 seconds

Diskusi Terakhir

  • No posts to display.

Joomla User Group Indonesia

Joomla User Group indonesia

Id-joomla.com adalah situs resmi Joomla User Group (JUG) Indonesia dan Joomla Translation Team

 
Download Terjemahan Joomla terakreditasi dari JoomlaCode dan laporkan bugs, ide dan saran nya di Sub Forum Hanacaraka

Socials

twitter id joomlafb idjoomla