Question

After a portover of the joomla version 2.5.3 from a lampp to webserver i have the following trouble: i cannot login to my admin-area: what happened!?

500 - An error has occurred.
Return to Control Panel

在通过Sitomyadmin把垃圾堆放到垃圾桌旁时,所有物体都走过了冰,但――突然发现用户表中的微粒错误......

MySQL says ,,, [and i guess that it was told with a prefix - a preliminary notice that told me that the users-table was not ported over due to some errors... (guessing that the local and the "web-server-database are not 100 % simmilar and equvialent... What do you say!? But - besides this - if you have a closer look at the number of tables then we see that there are tables missing... that is the important thing .... i cant help myself - there are several tables missiing.!!

#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=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9  at line 17

so then i have to do the portover of the users-table manually. but as i see now - there are more tables missing. approximatly 5 to seven tables were missing and - as mentioned above - i was not able to login

500 - An error has occurred.
Return to Control Panel

一些调查结果: 一些朋友告诉我,这要与 d子的遵守有关——当地酒吧不像网络服务器那样。

因此,我决定重新上载用户区域的全部分辨率。 tables! 因此,现在需要掌握一些新谢物的表格——即需要完整的表格——所有与“用户”在“joomla-version”中做的事情。

Guess that these are the following tables:

oqlgu_user_notes    
oqlgu_user_profiles     
oqlgu_user_usergroup_map    
oqlgu_usergroups
oqlgu_users

www.un.org/spanish/ecosoc 两个问题:是需要的所有表格? 你们能告诉我,他们在哪里?

Answer 1

您的MySQL数据库版本是否匹配? 你们需要使用同样版本的MySQL机,或调整SQ,使之与生产服务器的版本相匹配。

Before MySQL 5.0.60, this option can be given only before the ON tbl_name clause. Use of the option in this position is deprecated as of 5.0.60 and support for it there will be removed in a future MySQL release. If an index_type option is given in both the earlier and later positions, the final option applies.

TYPE type_name is recognized as a synonym for USING type_name. However, USING is the preferred form.

友情链接