If you're interested in helping other members with support requests, consider joining the Community Support Helpers group.


SimplePortal

SimplePortal's bugs.

Bug Issue: Re: SimplePortal 2.3.4 Beta 4

Pages: [1]   Go Down

Offline Underdog

  • Support
  • *
  • Posts: 562
  • Gender: Male
  • SMF Arcade Admin
    • Underdog-01 GitHub Repositories
« 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.
Logged

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! :)
Logged

Offline [SiNaN]

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

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 5945
  • Gender: Male
  • AngelinaBelle Fan!
« 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...
Logged
And slowly, you come to realize... It's all as it should be...

Offline Underdog

  • Support
  • *
  • Posts: 562
  • Gender: Male
  • SMF Arcade Admin
    • Underdog-01 GitHub Repositories
« Reply #4 on: October 29, 2011, 04:20:05 PM »
Quote from: [SiNaN] on October 29, 2011, 01:53:43 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...

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.
Logged

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 5945
  • Gender: Male
  • AngelinaBelle Fan!
« 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.
Logged
And slowly, you come to realize... It's all as it should be...

Offline Underdog

  • Support
  • *
  • Posts: 562
  • Gender: Male
  • SMF Arcade Admin
    • Underdog-01 GitHub Repositories
« 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 »
Logged

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 5945
  • Gender: Male
  • AngelinaBelle Fan!
« 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] »
Logged
And slowly, you come to realize... It's all as it should be...

Offline Underdog

  • Support
  • *
  • Posts: 562
  • Gender: Male
  • SMF Arcade Admin
    • Underdog-01 GitHub Repositories
« 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).

Logged

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 5945
  • Gender: Male
  • AngelinaBelle Fan!
« Reply #9 on: November 06, 2011, 12:24:11 PM »
 ! Character case difference for expected and given table names.
Logged
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 »
Logged
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