Thanks for having an interest with our portal. If you have any requests for features, have a look at the Feature Requests board.


SimplePortal

SimplePortal's bugs.

Bug Issue: Re: SimplePortal 2.3.4 Beta 4

Pages: [1]   Go Down

Offline Underdog

  • Support
  • *
  • Posts: 808
  • Gender: Male
  • On Hiatus
    • WebDev
« on: October 22, 2011, 03:22:18 PM »
SimplePortal 2.3.4 Beta 4

Uninstalling and then re-installing gives table exists errors.

Tested several times on a local.

Offline sharks

  • Beta Tester
  • *
  • Posts: 28
« Reply #1 on: October 22, 2011, 05:56:07 PM »
It feels great to see Beta 4 is out! :)

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6471
  • The Amazing Coder!
« Reply #2 on: October 26, 2011, 08:26:41 AM »
Which SMF version? What's your MySQL version? Is it running on strict mode?
And slowly, you come to realize... It's all as it should be...

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6471
  • The Amazing Coder!
« Reply #3 on: October 29, 2011, 01:53:53 AM »
I'm unable to reproduce this one with 2.3.4 Beta 4 rev 100 on SMF 1.1.15 and 2.0.1. I really need more feedback. Also the exact error message...
And slowly, you come to realize... It's all as it should be...

Offline Underdog

  • Support
  • *
  • Posts: 808
  • Gender: Male
  • On Hiatus
    • WebDev
« Reply #4 on: October 29, 2011, 04:20:05 PM »
I'm unable to reproduce this one with 2.3.4 Beta 4 rev 100 on SMF 1.1.15 and 2.0.1. I really need more feedback. Also the exact error message...

Yes I have been away for a few days.

re. Simple Portal v2.3.4 rev100

So far the SMF 2 installation seems to work fine.
However for a fresh install of SMF 1.1.15 I get this error when uninstalling/installing the same version:
Quote
Table 'smf1_115_2_sp_articles' already exists
File: C:\xampp\htdocs\XXXXX\Packages\temp\install1-1.php
Line: 1124

If I manually delete the table other errors show for additional tables upon installation.

mysql version: 5.1 (mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ )
non-strict mode.

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6471
  • The Amazing Coder!
« Reply #5 on: October 30, 2011, 03:47:10 AM »
Copy the install1-1.php file from the package to the forum root, make this change:

Code: (Find) [Select]
// Loop through each table and do what needed.
Code: [Select]
var_dump($current_tables);
// Loop through each table and do what needed.

Then to go http://url.to/forum/install1-1.php address. You should see something like this at the top of the page:

Code: [Select]
array(7) { [0]=> string(15) "smf_sp_articles" [1]=> string(13) "smf_sp_blocks" [2]=> string(17) "smf_sp_categories" [3]=> string(12) "smf_sp_pages" [4]=> string(17) "smf_sp_parameters" [5]=> string(17) "smf_sp_shoutboxes" [6]=> string(13) "smf_sp_shouts" }
If you see that, try making this change:

Code: (Find) [Select]
if (in_array($real_prefix . $table, $current_tables))
Code: (Replace) [Select]
var_dump($real_prefix . $table);
if (in_array($real_prefix . $table, $current_tables))

Then copy and paste the contents of the resulting page here.
And slowly, you come to realize... It's all as it should be...

Offline Underdog

  • Support
  • *
  • Posts: 808
  • Gender: Male
  • On Hiatus
    • WebDev
« Reply #6 on: November 01, 2011, 03:34:05 PM »
Code: [Select]
array(7) { [0]=> string(22) "smf1_115_2_sp_articles" [1]=> string(20) "smf1_115_2_sp_blocks" [2]=> string(24) "smf1_115_2_sp_categories" [3]=> string(19) "smf1_115_2_sp_pages" [4]=> string(24) "smf1_115_2_sp_parameters" [5]=> string(24) "smf1_115_2_sp_shoutboxes" [6]=> string(20) "smf1_115_2_sp_shouts" } string(22) "SMF1_115_2_sp_articles"

\\Edit-> ... used code bbc for display.
« Last Edit: November 02, 2011, 01:41:07 PM by Underdog »

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6471
  • The Amazing Coder!
« Reply #7 on: November 04, 2011, 10:47:18 AM »
Okay. Revert those changes back, apply this change and see if it works:

Code: (Find) [Select]
if (in_array($real_prefix . $table, $current_tables))
Code: (Replace) [Select]
if (in_array(strtolower($real_prefix . $table), array_map('strtolower', $current_tables)))
« Last Edit: November 04, 2011, 10:47:38 AM by [SiNaN] »
And slowly, you come to realize... It's all as it should be...

Offline Underdog

  • Support
  • *
  • Posts: 808
  • Gender: Male
  • On Hiatus
    • WebDev
« Reply #8 on: November 04, 2011, 06:20:17 PM »

Yes, that works fine now using your edit.

I see how you did it there.. queried all tables into an array & then check if each table is in the array.

... char case issue? 
I had it working proper by adding my own routine to check tables using SHOW TABLES LIKE .. char case did not cause an issue (more overall queries but it's just an installer).


Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6471
  • The Amazing Coder!
« Reply #9 on: November 06, 2011, 12:24:11 PM »
 ! Character case difference for expected and given table names.
And slowly, you come to realize... It's all as it should be...

Offline sharks

  • Beta Tester
  • *
  • Posts: 28
« Reply #10 on: November 08, 2011, 01:31:33 PM »
After some long bug chases, it looks like we'll finally have a pre-Christmas release. :bandaged:
« Last Edit: November 08, 2011, 01:32:08 PM by sharks »

Pages: [1]   Go Up

Issue Changes

Change Member Time
Status changed from Feedback to Resolved [SiNaN] November 06, 2011, 12:24:11 PM
Issue Assigned from (none) to [SiNaN] [SiNaN] November 06, 2011, 12:24:11 PM
Status changed from New to Feedback [SiNaN] October 29, 2011, 01:53:53 AM

Issue Details

  • Reported
    October 22, 2011, 03:22:18 PM
  • Updated
    November 08, 2011, 01:31:33 PM
  • View Status
    Public
  • Type
    Bug
  • Status
    Resolved
  • Priority
    Normal
  • Version
    2.0.x, 2.0.4/SMF 1.1.5
  • Fixed in
    (none)
  • Assigned to
    [SiNaN]
  • Category
    Function

Tags



Powered by: SMF Project Tools 0.5.4 © Niko Pahajoki 2007-2011