collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 521
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Installation errors? Mod incompatibilities? Upgrade problems? Make your way over to the Install and Upgrade Support board for all your solutions!

Author Topic: Database Error After Upgrade to RC5  (Read 5040 times)

0 Members and 1 Guest are viewing this topic.

Offline hannah.love7

  • Semi Newbie
  • *
  • Posts: 15
  • SMF Version: None
  • SP Version: None
Database Error After Upgrade to RC5
« on: April 16, 2011, 09:31:50 AM »
Database Error
Invalid default value for 'approved'
File: ........../donnaforex.com/httpdocs/forum/Packages/temp/install2.php
Line: 501

I just upgraded my forum from 2.0 RC3 to 2.0 RC5. Before upgrading, i uninstalled Simple Portal. THe upgrade to RC5 went fine, and i reloaded most of my mods with no problem. There are two mods producing the above error, simple portal, and advanced reputation. It shows at the point where it tries to install (after accepting the file changes, the bit where you click continue and it executes the changes).

Sorry to be a pain with so many questions - i probably shouldn't have upgraded and just left RC3 alone since it took so long to make it all work smoothly :)

My forum is www.donnaforex.com/forum

Offline AngelinaBelle

  • Comrade
  • *
  • Posts: 4870
  • Gender: Female
  • SMF Version: 2 RC3
  • SP Version: 2.3.2
Re: Database Error After Upgrade to RC5
« Reply #1 on: April 19, 2011, 08:50:13 AM »
This odd error occurs on some forums and not on others, following RC5 upgrade.
I've reported this to the tracker (http://simpleportal.net/index.php?issue=415.0)
If you are upgrading from a recent version of SimplePortal, this workaround should get you going:
http://simpleportal.net/index.php?topic=7646.msg42599#msg42599
It just removes the part of the install package where the database gets updated.
If that is not appropriate in your case, please let me know. I can help you work with install2.php.
 
Please to keep this website running, if you like SimplePortal, make a
one-time subscription. Thank you for your support.

Have you tried the SimplePortal documentation?

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Database Error After Upgrade to RC5
« Reply #2 on: April 19, 2011, 08:57:33 AM »
First make this change:

./Settings.php

Code: (Find) [Select]
?>
Code: (Replace) [Select]
$db_show_debug = true;
?>

Then try installing the mod again. It should provide you a more detailed error. If you copy that here for me, I'll have a better idea about what's causing the error.
And slowly, you come to realize... It's all as it should be...

Offline hannah.love7

  • Semi Newbie
  • *
  • Posts: 15
  • SMF Version: None
  • SP Version: None
Re: Database Error After Upgrade to RC5
« Reply #3 on: April 20, 2011, 02:21:51 AM »
I tried adding that code and here is the debug info i get:


Invalid default value for 'approved'
File: /var/www/vhosts/donnaforex.com/httpdocs/forum/Packages/temp/install2.php
Line: 501


ALTER TABLE smf_sp_articles
CHANGE COLUMN `approved` `approved` tinyint(2) NOT NULL default ''

Offline hannah.love7

  • Semi Newbie
  • *
  • Posts: 15
  • SMF Version: None
  • SP Version: None
Re: Database Error After Upgrade to RC5
« Reply #4 on: April 20, 2011, 02:23:29 AM »
I have the same problem on another mod i'm trying to reinstall too, the advanced reputation mod. I installed it manually in the end but cannot run the install.php file and the mod doesn't work correctly as a result.
Will using the workaround mean that parts of simple portal won't work? What does the install file actually do?

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Database Error After Upgrade to RC5
« Reply #5 on: April 20, 2011, 08:13:05 AM »
I see. You can revert that change back.

I could gave you the changes to fix this for SP, but since you seem to be having the same issue with other mods, this should fix it for all:

Sources/DbPackages-mysql.php

Code: (Find) [Select]
// Allow for unsigned integers (mysql only)
Code: (Replace) [Select]
if ($column_info['default'] === '' && in_array($type, array('int', 'tinyint', 'smallint', 'mediumint', 'bigint')))
$column_info['default'] = 0;

// Allow for unsigned integers (mysql only)
And slowly, you come to realize... It's all as it should be...

Offline AngelinaBelle

  • Comrade
  • *
  • Posts: 4870
  • Gender: Female
  • SMF Version: 2 RC3
  • SP Version: 2.3.2
Re: Database Error After Upgrade to RC5
« Reply #6 on: April 20, 2011, 08:30:20 AM »
Thanks for supplying the complete information about your error.
This will help SimplePortal's developers improve the installer.
Currently, some users receive this error message -- some do not.
If you are curious, you can have a look at the install2.php file yourself. SimplePortal's install file makes changes to the database, creating SimplePortal tables if necessary, and updating them if necessary. In your case, though, going from SimplePortal 2.3.2 to 2.3.3 and SMF 2RC3 to 2RC5, I do not think any changes to the SimplePortal tables ought to be necessary. This is why I suggest that skipping install2.php would be an OK way to work around this problem.
If you are having the same problem with another mod, it may be caused by the same problem (related, I think, to changes in SMFs database functions). I cannot tell you if skipping that part of the installation for some other mod will work. It might, or it might be necessary to alter the other mod's install php file to get it working -- I just can't know.
 
Please to keep this website running, if you like SimplePortal, make a
one-time subscription. Thank you for your support.

Have you tried the SimplePortal documentation?

Offline hannah.love7

  • Semi Newbie
  • *
  • Posts: 15
  • SMF Version: None
  • SP Version: None
Re: Database Error After Upgrade to RC5
« Reply #7 on: April 20, 2011, 12:24:05 PM »
Thanks for your replies :).

I made the change to the code and managed to complete install of my half-installed reputation mod... now just taking a breather and collecting myself before i close my eyes and pray that simple portal goes through OK (no reflection on simple portal here, i'm the same with any mod at all, my heart is still pounding from just completing that code change!). I'm hopeful that it will all work out!

I did not mean to suggest that i'm asking for solutions for my other mods, i mentioned it because it could give you further important info that was all, because i was thinking it's not really your mod if it's happening to other ones too. Although i really appreciate the solution above which it looks like has resolved all my problems.

Well i'm rambling on here, i'll let you know when i've added simple portal ... hopefully later today. Might go have a big glass of wine before proceeding :-).

I see you upgraded the SimplePortal site here.... all looking good :)

Offline hannah.love7

  • Semi Newbie
  • *
  • Posts: 15
  • SMF Version: None
  • SP Version: None
Re: Database Error After Upgrade to RC5
« Reply #8 on: April 20, 2011, 03:27:56 PM »
Ok... i did it!!! Installed Simple Portal - no problems now!!! yayyyyy i'm so proud of myself, and the great support here, thanks so much for your help.
p.s. i know it doesn't show right now, i'll be adding blocks over the next few days... i'm just thrilled for now that i added it and it works great

Offline Stern

  • Newbie
  • Posts: 3
  • Gender: Male
    • On-line FotoSchool "VneFormat"
Re: Database Error After Upgrade to RC5
« Reply #9 on: April 22, 2011, 08:27:18 AM »
I see. You can revert that change back.

I could gave you the changes to fix this for SP, but since you seem to be having the same issue with other mods, this should fix it for all:

Sources/DbPackages-mysql.php

Code: (Find) [Select]
// Allow for unsigned integers (mysql only)
Code: (Replace) [Select]
if ($column_info['default'] === '' && in_array($type, array('int', 'tinyint', 'smallint', 'mediumint', 'bigint')))
$column_info['default'] = 0;

// Allow for unsigned integers (mysql only)
Thank you, SiNaN, all upgrades excellent!
Before that, I found another solution, but your advice - the best and globally!

Offline S.T.A.R.S

  • Semi Newbie
  • *
  • Posts: 46
  • Developer @ www.mmogamer.co.uk - Gaming Forums
  • SMF Version: 2 RC5
  • SP Version: None
Re: Database Error After Upgrade to RC5
« Reply #10 on: June 24, 2011, 02:39:44 PM »
:/ Dont think it is.

I had inputted that code within the php file. I had installed it now.



But. I cannot see any simple portal features or anything, its like it never even installed. :/ I get this with everymod since i ever installed the first SMF on my server.

thanks


www.mmogamer.co.uk - Multi Gaming Forums. Talk and Dicuss with other games world wide, we support all genres of games.