Forum database table prefix

[artshock]

By mistake I have changed (in Classifieds admin) the forum database table prefix (for SMF2) and then my whole Classifieds section crushed. In what file (I assume php) is this information stored? I hope I can go in there and manually set it back to the correct value. Also I have a weird problem with cookies, or so it looks to be. I have the following apps integrated on my site: PhotoPost, Reviews, Classifieds and SMF2. The login and register from all of them point to SMF since this is the application which handles this kind of functionality. When I am in IE8, once a user (or administrator for that matter) logs in it is logged in in all four applications. In Mozilla 3.6.8 (the latest and the greatest version), the user is properly logged in only in PhotoPost and SMF2. What shall I do about it?

Thank you!

[Chuck S]

This is not a file it is setting 83 in the actual cp_settings table in your classifieds database.

You need to use phpmyadmin to change this or rerun the install script.

[artshock]

Thank you, Chuck! Problem solved. I still have the issue with Mozilla (as per my initial posting). Classifieds it does some other weird stuff also. I have two products listed (for testing purposes), and even if the user can see the listing (with thumbnails and description) when trying to access them the system reports back an error (as well as when the user is trying to see/edit its own profile). One of the errors I get is the following: "We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT value FROM lf_settings WHERE variable='custom_avatar_url'

Result: Table 'livefoli_dbclass.lf_settings' doesn't exist

Database handle: Resource id #5"
The problem here is in the database querry - 'mydomain_dbclass.lf_settings'. The table called 'lf_settings' in fact belongs to my forum database (SMF2) and not to 'dbclass' which is my Classifieds database. This error is reported when the user is logged in and is trying to access an item.
If not logged in the following error occurs:
"We're sorry, but the system experienced an unrecoverable error. Please try again later.
".
Any ideas on this one?

Thank you!
DVD

[Chuck S]

Have you uploaded the new smf2.php file from the distribution?

[artshock]

What do you mean by that? In my Classifieds folder there is another folder called "forums" which contains a file named "smf2.php". Should I replace it with a newer one?

[Chuck S]

Yes if you have uploaded the latest code your file should not have this error. I am assuming you did not replace this file when you upgraded.

[artshock]

How do I get the new file then?

[artshock]

And by the way, this was a new install not an upgrade.

[artshock]

Do I also need to update the same smf2.php on Reviews?

[Chuck S]

In our downloaded smf2.php file the line is this

Content visible to verified customers only.

[artshock]

Hi Chuck,

Thank you very much! This is the fix. Now everything looks to be in order. I guess I had an old file, since my equivalent string was like this:
list( $avatarurl ) = ppmysql_query_onerow("SELECT value FROM {$Globals['dprefix']}settings WHERE variable='custom_avatar_url'", $link);
$avcheck = substr($uavatar, 0, 4);
In reviews I don't have any issues so far, but I am wondering if there is a similar thing in the smf2.php file. Any hints will be much appreciated.

Regards,
DVD

[artshock]

Unfortunately this doesn't seem to be the end of the problem. Now under "Profile" in classifieds the avatar is not shown any longer and the IE8/Mozilla 3.6.8 issue is still there ...

[Chuck S]

I can not comment on cookie issues without seeing the settings in both applications.

[artshock]

You should have the ftp info for my site - I sent it to you not too long ago. If you can't find it please let me know.

Regards,
DVD

[Chuck S]

You would need to send site data since we have many customers. I dont keep old emails given the number of emails I deal with weekly.

[artshock]

Hi Chuck,

I sent you last night the ftp info via "Contact us". I forgot to mention though the site structure:
buysell - folder for Classifieds
reviews - folder for Reviews
folios - folder for PhotoPost
liveforum - folder for SMF2

Thank you!

[Chuck S]

I will check but make sure you also included admin information.

[Chuck S]

You have not provided admin info so I can look at your cookies and login

[artshock]

Hi Chuck,

Sorry about it. I will send to you the required via via "Contact us" ASAP.

Thank you!

[Chuck S]

Thanks am checking this out now.