Warning: The author of this contribution does not provide support for it anymore.

User Blog Mod

SQL ERROR - User Blog Mod

SQL ERROR

by Meis2M » Sun Feb 20, 2011 4:16 pm

Hi i this address this is error
http://www.zohall.com/forum/blog/database.php

in acp when i go to blog system i will se this error

Code: Select all

SQL ERROR [ mysqli ]

Table 'zohallco_forum.BLOGS_PLUGINS_TABLE' doesn't exist [1146]

SQL

SELECT * FROM BLOGS_PLUGINS_TABLE ORDER BY plugin_id ASC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: blog/plugins/plugins.php
LINE: 52
CALL: dbal_mysqli->sql_query()

FILE: blog/functions.php
LINE: 32
CALL: blog_plugins->__construct()

FILE: includes/acp/acp_blogs.php
LINE: 37
CALL: include('blog/functions.php')

FILE: includes/functions_module.php
LINE: 507
CALL: acp_blogs->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


so i deleted manual blog table in phpmyadmin. now when i go to
http://www.zohall.com/forum/blog/database.php

i will see this error

Code: Select all

SQL ERROR [ mysqli ]

Table 'zohallco_forum.phpbb_blogs_plugins' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


now i cant install or uninstall this mod. blog/database.php not working. i need SQL command to add manual tables in phpmyadmin.
thank u
phpBB persian international support
Follow us in Instagram
Free upgrade and install extensions on your forum - drop me PM
Ultimate phpBB SEO Friendly URL extension
User avatar
Meis2M
Translator
Posts: 943
Joined: Wed Mar 03, 2010 11:32 am
Location: IR.Damghan
Name: میثم نوبری
Contact:

Re: SQL ERROR

by EXreaction » Sun Feb 20, 2011 11:46 pm

Do you have another mod installed that has the constant BLOGS_TABLE defined or something?
User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan
Contact:

Re: SQL ERROR

by Meis2M » Mon Feb 21, 2011 5:43 am

no i did not
phpBB persian international support
Follow us in Instagram
Free upgrade and install extensions on your forum - drop me PM
Ultimate phpBB SEO Friendly URL extension
User avatar
Meis2M
Translator
Posts: 943
Joined: Wed Mar 03, 2010 11:32 am
Location: IR.Damghan
Name: میثم نوبری
Contact:

Re: SQL ERROR

by Meis2M » Mon Feb 21, 2011 5:44 am

can u give me sql command to add manual tables from phpmyadmin?
phpBB persian international support
Follow us in Instagram
Free upgrade and install extensions on your forum - drop me PM
Ultimate phpBB SEO Friendly URL extension
User avatar
Meis2M
Translator
Posts: 943
Joined: Wed Mar 03, 2010 11:32 am
Location: IR.Damghan
Name: میثم نوبری
Contact:

Re: SQL ERROR

by EXreaction » Mon Feb 21, 2011 8:14 am

No, you need to use the script, the original error wasn't caused by the table missing, something was wrong with the constants.
User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan
Contact:

Re: SQL ERROR

by Meis2M » Mon Feb 21, 2011 8:49 am

thank u i repaired it. now working fine
phpBB persian international support
Follow us in Instagram
Free upgrade and install extensions on your forum - drop me PM
Ultimate phpBB SEO Friendly URL extension
User avatar
Meis2M
Translator
Posts: 943
Joined: Wed Mar 03, 2010 11:32 am
Location: IR.Damghan
Name: میثم نوبری
Contact:

Re: SQL ERROR

by pacificfils » Mon Oct 01, 2012 9:58 pm

How?
Disclaimer: I am NOT responsible for damages to any board but my own. If something goes wrong, I'm not responsible. It is YOUR decision to do what YOU want to do with YOUR board.

YOU HAVE BEEN WARNED!
pacificfils
Registered User
Posts: 16
Joined: Mon Sep 03, 2012 8:28 pm
Name: 10010001001101 00010111000101
Contact: