Advertisement:

Author Topic: Wrong value type sent to the database. Integer expected. (page_id)  (Read 930 times)

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
A user encountered this error today: (I replaced private path info with "---")

Quote
Type of error: Critical
Error message:
Wrong value type sent to the database. Integer expected. (page_id)
Function: Display
File: ---/Sources/Display.php
Line: 948
URL of page causing the error: ---

Is there currently a patch?
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,373
  • Gender: Male
    • Kindred-999 on GitHub
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #2 on: May 13, 2021, 03:05:41 PM »
there was a PR fix merged 6 months ago....
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #3 on: May 13, 2021, 09:33:54 PM »
there was a PR fix merged 6 months ago....

I'm running PrettyURLs that modifies that file.  What's the best way to roll out those changes and keep the PrettyURL mod changes?  What's the "proper SMF way" to do it?
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,373
  • Gender: Male
    • Kindred-999 on GitHub
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #4 on: May 14, 2021, 08:00:15 AM »
what I mean is --   why are you not running a version that is less than 6 months old, given the 100+ fixes put into the code after the initial RC3 release? :P
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 648
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #5 on: May 14, 2021, 09:35:24 AM »
why is smf providing a version which is older than 6 month  ;)?

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 20,114
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • Aleksi Kilpinen
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #6 on: May 14, 2021, 10:53:36 AM »
why is smf providing a version which is older than 6 month  ;)?
Tehcnically, we are offering a later version as well - RC4 isn't out yet, but development version on Github is public.
« Last Edit: May 14, 2021, 11:15:01 AM by Aleksi "Lex" Kilpinen »
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline shadav

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 1,452
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Foamy Fanatics :: For All Your Foamy The Squirrel Needs
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #7 on: May 14, 2021, 11:51:10 AM »
why is smf providing a version which is older than 6 month  ;)?
um because it's still in release candidate...it's not a stable version...there is constant changes being made to it, to which anyone can grab the latest version off of github, but it's still not a stable product, it is only for testing purposes.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 11,090
  • We were all equal in the end.
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #8 on: May 14, 2021, 01:02:06 PM »
I'm running PrettyURLs that modifies that file.  What's the best way to roll out those changes and keep the PrettyURL mod changes? 

Best way to deal with Pretty URLs is do clean install to remove all code, drop database tables, delete code from .htaccess, and never, ever install it again. :P
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #9 on: May 14, 2021, 01:44:21 PM »
I'm running PrettyURLs that modifies that file.  What's the best way to roll out those changes and keep the PrettyURL mod changes? 

Best way to deal with Pretty URLs is do clean install to remove all code, drop database tables, delete code from .htaccess, and never, ever install it again. :P

I did that, but now my forum isn't pulling up.
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #10 on: May 14, 2021, 01:47:02 PM »
I guess what I'm asking is what's the best SMF way to roll out the new file and put back the PrettyURLs (or any mod's) changes?
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #11 on: May 14, 2021, 02:06:09 PM »
why is smf providing a version which is older than 6 month  ;)?
um because it's still in release candidate...it's not a stable version...there is constant changes being made to it, to which anyone can grab the latest version off of github, but it's still not a stable product, it is only for testing purposes.

I'll pull the latest versions off GH, but for those mods I have installed, I need to know the best way to deal with them to put them back.
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 648
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #12 on: May 14, 2021, 02:34:18 PM »
why is smf providing a version which is older than 6 month  ;)?
um because it's still in release candidate...it's not a stable version...there is constant changes being made to it, to which anyone can grab the latest version off of github, but it's still not a stable product, it is only for testing purposes.

the github version is not packages in a way where the user can download and run the stuff,
he had to move the right files from others in the root and this expect to mutch know how of smf to make it right.

on the other hand, the users get blamed when they find bugs in the released smf version,
since the version is to old and many of the issue got fixed.

so when you don't care of the result of the finding of the released rc version, why you guys released it?

Offline live627

  • Developer
  • SMF Hero
  • *
  • Posts: 5,965
  • Gender: Male
    • live627 on Facebook
    • live627 on GitHub
    • live627 on LinkedIn
    • @live627 on Twitter
    • livemods
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #13 on: May 14, 2021, 03:48:26 PM »
why is smf providing a version which is older than 6 month  ;)?
um because it's still in release candidate...it's not a stable version...there is constant changes being made to it, to which anyone can grab the latest version off of github, but it's still not a stable product, it is only for testing purposes.

I'll pull the latest versions off GH, but for those mods I have installed, I need to know the best way to deal with them to put them back.
Since everybody prefers to squabble over other matters, I'll answer this. The procedure is just like a large upgrade—overwrite all files and re install all mods. Hope this helps.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 20,114
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • Aleksi Kilpinen
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #14 on: May 14, 2021, 03:49:12 PM »
There's no need for the hostility. RC4 will be coming, with the packages generated. It's just not there yet.
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #15 on: May 14, 2021, 07:04:40 PM »
why is smf providing a version which is older than 6 month  ;)?
um because it's still in release candidate...it's not a stable version...there is constant changes being made to it, to which anyone can grab the latest version off of github, but it's still not a stable product, it is only for testing purposes.

I'll pull the latest versions off GH, but for those mods I have installed, I need to know the best way to deal with them to put them back.
Since everybody prefers to squabble over other matters, I'll answer this. The procedure is just like a large upgrade—overwrite all files and re install all mods. Hope this helps.

Excellent.  Thank you!
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 11,090
  • We were all equal in the end.
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #16 on: May 14, 2021, 09:58:45 PM »
I'll pull the latest versions off GH, but for those mods I have installed, I need to know the best way to deal with them to put them back.

If you start out with a clean install, clean database, and clean .htaccess, you should be able to install 2.1 mods with package manager, assuming the mods have been updated to be compatible with latest github release.  As noted, 2.1 is still in RC, so it's a moving target for mod authors.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #17 on: May 16, 2021, 03:37:46 PM »
I'll pull the latest versions off GH, but for those mods I have installed, I need to know the best way to deal with them to put them back.

If you start out with a clean install, clean database, and clean .htaccess, you should be able to install 2.1 mods with package manager, assuming the mods have been updated to be compatible with latest github release.  As noted, 2.1 is still in RC, so it's a moving target for mod authors.

It's a 10-year old DB converted from 2.016.  From what I gather, I can just bring over all the files newer than the last RC3.
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 11,090
  • We were all equal in the end.
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #18 on: May 16, 2021, 10:41:51 PM »
Would be best to upload the complete package and run upgrade.php, there may be changes to database.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline cpf

  • Semi-Newbie
  • *
  • Posts: 88
    • Conservative Political Forum
Re: Wrong value type sent to the database. Integer expected. (page_id)
« Reply #19 on: May 17, 2021, 06:44:49 PM »
Would be best to upload the complete package and run upgrade.php, there may be changes to database.

Will do, thank you.  I'll report back.
Don't email me, PM me, IM me, contact me, look at me, breath on me, or even attempt to think about thinking of contacting me.  If you do, I will send you to the correct forum to post, where I will promptly tell you that you posted in the wrong forum.