General Error - SQL ERROR [ mysqli ].

Discussions about the phpBB3 Forum. How to get the best from this powerful script.
Note that there is no official support for phpBB3 here, a place to share more than to ask for.

Moderator: Moderators

General Error - SQL ERROR [ mysqli ].

Postby ayyan » Sun Feb 07, 2010 4:13 pm

I amhaving two errors firstone came up when i tried to edit a topic.

General Error
SQL ERROR [ mysqli ]

Unknown column 'topic_url' in 'field list' [1054]

SQL

UPDATE topics SET forum_id = 20, icon_id = 0, topic_approved = '1', topic_title = 'test', topic_url = '', topic_first_poster_name = 'Ayyan', topic_type = 0, topic_time_limit = 0, poll_title = '', poll_start = 0, poll_max_options = 1, poll_length = 0, poll_vote_change = 0, topic_last_view_time = 1265546614, topic_attachment = 0 WHERE topic_id = 49009

BACKTRACE

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

FILE: includes/functions_posting.php
LINE: 2076
CALL: dbal_mysqli->sql_query()

FILE: posting.php
LINE: 1027
CALL: submit_post()




2nd when i tried to delete a post.

SQL ERROR [ mysqli ]

Table 'ayyan.thanks' doesn't exist [1146]

SQL

DELETE FROM thanks WHERE post_id = 63791

BACKTRACE

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

FILE: includes/functions_thanks.php
LINE: 379
CALL: dbal_mysqli->sql_query()

FILE: posting.php
LINE: 1476
CALL: delete_post_thanks()

FILE: posting.php
LINE: 304
CALL: handle_post_delete()




Any solution for this ?
ayyan
 
Posts: 1
Joined: Sun Feb 07, 2010 4:08 pm

Advertisement

Re: General Error - SQL ERROR [ mysqli ].

Postby austin881 » Tue Feb 09, 2010 8:42 pm

What did you install?
What are you runnnig?
You installed zero dupe on what?
What was your site running before?
Did you start with preMod or is this a regular phpBB site with zero dupe recently installed?
What version are you running?
Do you have a live URL we can look at?
What did you do just before everything was working perfectly?
Was anything EVER working perfectly?
What edits did you just make?
What style are you running?
Prosilver based?
Subsilver based?
What does your .htaccess file say?
What zero dupe "mode" are you using?
What is your blood type? Social security number? Drivers license number?
My dev playground: Whoa.co
Appreciate my assistance? You can thank me by linking to my Chevrolet Astro forums.
User avatar
austin881
phpBB SEO Team
phpBB SEO Team
 
Posts: 249
Joined: Wed Oct 28, 2009 12:16 am
Location: Boise, Idaho USA


Return to phpBB Forum

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: Yahoo [Bot] and 45 guests