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

Topic Text in Mouse Over

Working OK EXCEPT ... - Topic Text in Mouse Over

Working OK EXCEPT ...

by ozweb » Fri Jun 24, 2011 10:34 pm

The mod is working perfectly except for two things. One very minor, in Firefox 4 it puts the preview box in the bottom left corner of the winow. Not too worried about that, seems to work in other browsers OK.

Second problem is a worry. In just one subforum, and only one subforum, (that I've discovered so far), trying to enter that subforum gives an SQL error. (See below). It doesn't matter if I enable or disable the mod in the UCP, it still does it. Why would it affect only one subforum? It isn't any different to any of the others, same permissions etc.

Version 3.0.8 of the software and Prosilver.

Here is the SQL error.

--------------------------------------------------------------------------------
General Error

SQL ERROR [ mysqli ]

Table 'austra22_bb1.bb_topicst' doesn't exist [1146]

SQL

SELECT t.* FROM bb_topicst WHERE t.topic_id = 651

BACKTRACE


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

FILE: viewforum.php
LINE: 518
CALL: dbal_mysqli->sql_query()

-----------------------------------------------------------------------------
Help!
ozweb
Registered User
Posts: 80
Joined: Thu Jan 27, 2011 2:10 am
Location: Australia
Contact:

Re: Working OK EXCEPT ...

by RMcGirr83 » Sat Jun 25, 2011 1:13 am

The edits to the php file concerned are incorrect.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21057
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Working OK EXCEPT ...

by ozweb » Sat Jun 25, 2011 5:19 am

RMcGirr83 wrote:The edits to the php file concerned are incorrect.


OK but that file is not in the mod that I downloaded and it's not in the list of files to edit. I certainly didn't edit it so would it have been done somehow by the update.php file when I ran it?

In any case, what do I need to do to fix it?
ozweb
Registered User
Posts: 80
Joined: Thu Jan 27, 2011 2:10 am
Location: Australia
Contact:

Re: Working OK EXCEPT ...

by ozweb » Sat Jun 25, 2011 5:23 am

I just noticed that it says a table doesn't exist. Maybe the update file didn't work properly. Should I run it again?
ozweb
Registered User
Posts: 80
Joined: Thu Jan 27, 2011 2:10 am
Location: Australia
Contact:

Re: Working OK EXCEPT ...

by RMcGirr83 » Sat Jun 25, 2011 10:52 am

The file is most definitely in the list to be edited as it is viewforum.php that is causing your problem and as I said, you did the edits incorrectly.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21057
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Working OK EXCEPT ...

by ozweb » Sun Jun 26, 2011 12:21 am

Sorry, you are correct, I was looking at the file mysqli.php mentioned in the SQL error report. I have no idea why I didn't look further down. Too much of a rush I guess.

Anyway, I got the original (backup) of viewforum.php and did another edit of it carefully following the instructions. Got the same result, (yes, I purged the cache). I cannot for the life of me figure out where I've got it wrong. No doubt I've put a comma in the wrong place or some bloody thing but I just can't see it.

Here is the part of the file that it seems to be complaining about:

-------------------------------------------------------------------
$sql = 'SELECT t.*' . $sql_select . '
FROM ' . TOPICS_TABLE . 't
' . $sql_join . '
WHERE ' . $db->sql_in_set('t.topic_id', array_keys($shadow_topic_list));
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
$orig_topic_id = $shadow_topic_list[$row['topic_id']];

-----------------------------------------------------------------------

Can you tell me what I've done wrong. In the latest SQL error it tells me that it doesn't like line 516 which is:

$result = $db->sql_query($sql);

Yes, I'm sure I've stuffed up somewhere but I just can't see it. I'm a very very long way from knowing anything about php coding so I need some help here. Thanks.
ozweb
Registered User
Posts: 80
Joined: Thu Jan 27, 2011 2:10 am
Location: Australia
Contact:

Re: Working OK EXCEPT ...

by RMcGirr83 » Sun Jun 26, 2011 3:38 am

You need a space in here

Code: Select all

FROM ' . TOPICS_TABLE . 't


directly before the "t"
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21057
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Working OK EXCEPT ...

by ozweb » Sun Jun 26, 2011 4:20 am

OK, that was it, just a bloody space. I knew it would be something as "simple" as that!

Thank you for your help.
ozweb
Registered User
Posts: 80
Joined: Thu Jan 27, 2011 2:10 am
Location: Australia
Contact: