TP TinyPortal 2.0.0 RC1 / SMF 2.0.17- Database Error

[tino]

Can you confirm you have the TPCompat file in your sources directory.

Also if you can query the database can you go to the smf_settings table and check that the integrate_pre_include setting has TPCompat.php there.

[Gavin Chatt]

Hi Tino,

I can confirm I have TPCompat.php file under Sources.

Went through 9 pages under smf_settings table and was unable to see integrate_pre_include. Not sure if I am however in the right section tho. See attached

[lurkalot]

Hi Gavin, long time no see. (assuming this is your original username on here = Gav-Aus)

So you say you're "using a very fresh / new forum board" What's the story here? A little background info might help to track down the issue. I think the last time we chatted you were running SMF 1.1.15 and TP 1.0

[Gavin Chatt]

Hi Mick,

Yes it is I "lol"

I think last time we caught up feels like 20 years ago . I ended up having a stroke and ended up closing off many things including the online stuff for around ten years . Still working through health issues however with COVID-19 decided to locate and contact all (or as many as) the old members who used to run online with us all those years ago and as such have been looking to bring back our online gaming once again.

Glad to see your still here

In the last few weeks starting to put together a new web page and forum, I decided to go back to SMF and knowing how great TP was went down this road again "lol"

I've been able to build up a great board and starting to learn again the TinyPortal side again had everything set and in use, my last back up was Sept 26th so a lot of data had been added since however as I'd not added mods etc had not backed-up. The issue has come in to play when I tried to add a new left block which I was looking to use for the calendar as I remembered all those years back we could have a board to list calendar events which would be seen by those with the permission set.

I added the detail and generated the block however it failed, not seeing the wood for the trees tried to save again with the same result so selected back and boom had the error as noted on the first post.

Database error, given array of integer values is empty. (cat)

I've now assumed the issue was because I had not added the "category" option. I was unable to access the boards so went via the database (stupid I know) looking for the issue, located the last block noted as Calendar and drop'd the table.

Still had the issue and found my way searching these very boards .

Tino has tried very hard to help out and suggested the do_hooks.php option however after trying this the error received is

Call to undefined function TPortalHookLoadTheme()

Additional suggestions have been made but this is where we're at now.

BTW, My health is much better, I can drive, dance and do very well considering Still have other issues and need to take care but enjoying things again.

[tino]

The following should show if the variable exists

Code Select Expand

SELECT value FROM smfyj_settings WHERE variable = 'integrate_pre_include'

If it doesn't show anything can you run the following

Code Select Expand

INSERT INTO smfyj_settings ( variable, value ) VALUES ( 'integrate_pre_include' , '$sourcedir/TPCompat.php' )

[Gavin Chatt]

Hi Tino,

I've now reviewed the database and don't see the

Code Select Expand

SELECT value FROM smfyj_settings WHERE variable = 'integrate_pre_include'

So I had a couple of goes to insert (not really knowing what I'm doing) but managed to get this to now show.

Code Select Expand

[INSERT INTO smfyj_settings ( variable, value ) VALUES ( 'integrate_pre_include' , '$sourcedir/TPCompat.php' )

Hoping I have completed this right. Tried the domain and received

This page isn't working
austeamracing.com.au is currently unable to handle this request.
HTTP ERROR 500

[tino]

Do you have an admin access you could PM me?

I think that's going to be most sensible now.

If not then I'll need to know what is in your Apache error log.

[Gavin Chatt]

Hi Tino

Just sent you a PM

Sorry to be such a pain and thank you for such great support.

[Gavin Chatt]

Hi Tino,

Sent another PM for you.

Thanks so much to where you have things right now

[@rjen]

Hi Tino,

Sent another PM for you.

Thanks so much to where you have things right now

Hey, it's back up! 

I trust that tino will let us (curious bystanders) know what happened...