An SMF PHP Related Question.:.

[arucarD]

I currently have SMF installed for my gaming forum over @ http://www.rev-gaming.info . I have been trying to modify the HELL out of it, as most basics and goals are easier achieved on the default theme then on custom ones.

[I do have a theme that will be customized, but that will be once I become more familiar with the PHP process again. Been years.]

Now my issue is this, I installed a modification called the Facebook Like Mod. Problem is, the mod is not working, and I also cannot create new forums without receiving this error :

Code: Select all

Field 'facebooklike_board_enable' doesn't have a default value
File: C:\inetpub\wwwroot\Sources\Subs-Boards.php
Line: 808

Now I know how to open the subs-boards.php and locate the lines, but I do not know what to edit the eliminate this error. I posted this on the modifications forum, but have not received a response, so for the PHP pros or those familiar with PHP tinkering, this ones for you. LoL

Any and all help would be appreciated, seeing as I have been going NUTS and editing / installing / working on this for 13 to 14 hrs a day for the past 3 days. O_O Cannot get anything done without determination.

[Edge100x]

From the error, it sounds as though you might need to modify a table in the database to set a default value for that field. But, I am not very familiar with SMF or the mod that you are adding. It might be best to ask this in a forum that specializes in SMF .

[arucarD]

Well as I stated, I did post it in the mods forum and specific thread, I received one response so far. "seems you have to install it manually. some of your mods had changed subs-boards.php"

Issue is, I do not know how to install it manually, as I look into the values it states what files it edits and with what code. But when I go to my packages, I cannot uninstall the modification either. [Usually a button stating uninstall will show for certain mods, I do have some that do not have it, but they are working properly.]

Its just like installing a mod for PHPBB3, and having a similar error. I just do not know where to start. If I was to uninstall it, I guess I would have to remove the tables from the DB, but would that remaining code inside the PHP files cause errors?

Thank you for your response btw.

[arucarD]

They are definitely database errors I seem to have been encountering. As it states such in the admin panel. Also I have encountered some general ones, but those do not have to do with this.

[Edge100x]

The first thing that I would recommend doing would be to manually go in through phpMyAdmin and search for that table and value, and set a default, if you can (likely using others in the table/database as guides). But, since this is such a SMF-specific question and I know essentially nothing about SMF, I can't provide much guidance beyond that.

If changes were made to on-disk files when you installed this, removing it would require undoing those changes, such as by reverting the patch, restoring the files from backup, or replacing them with the defaults.

[arucarD]

I wish I could use phpMyadmin, not even installed. I have not personally made any changes to any of the files, but when you install modifications they usually go to whatever php files they require and edit them. When I looked at my DB under workbench, it shows NOTHING about facebook like mod.. Not a table or anything.. Which is extremely awkward, seeing as it was installed to a forum and the files were written, but it seems the DB itself was not edited.

Makes no sense. :-/

As far as reverting the files, man I have done so many modifications since that mod was installed if I was to revert files back I would lose all of my progress and have to start from scratch... I am seriously trying to avoid that, but at the end of the day, I guess lesson learned.. I have spent 3 days at 14 to 16 hrs a day modifying and adding changes to the forum, to have to revert and start from scratch for something so simple is well.. Bullshit. lol

[arucarD]

Just chose to redo it period.. I have already spent a day and a half working through the issue with no resolve.. Good thing I wrote down my mods.. lol

[Edge100x]

We may also have a recent backup of your old site. If you open a support request on this, I can check that out for you.

[arucarD]

I dont think you would have one, im on an unmanaged VDS. I had no issues with anything, that was until I installed a facebook mod.. lmao The one mod that was working prior now is not working, currently have someone looking at it for me.

Ah man, issues issues.

[arucarD]

Issue has been fixed. I had to get an SQL / PHP master I know to check out the DB, he found the issue and corrected it.

look @ the field facebooksharer_board_enable
there is properly a property allowing you to set a default value to it

The DB just needed a property added to the section. Problem for me was finding it, but he found it in 2 seconds in WinHex. Damn coders. lol

[Edge100x]

He did what I was suggesting you try, yep . Glad it was that simple!