Topic: SimplePortal tables missing after upgrade/uninstall

[dex]

Hi i have this problem

Database Error
Duplicate key name 'state'
File: /xxx/xxx/public_html/Packages/temp/install2.php
Line: 521

but i make that

Easiest solution to that issue is to open up SimplePortal_2.3.2.zip and remove these lines of code from package-info.xml:

Code: [Select]
      <!-- Install scripts -->
      <database>install2.php</database>
To do that either extract the files to your computer, edit that one and recreate the archive, or edit it directly from 7zip (right-click -> Edit, make the changes and hit CTRL+S, then click yes when prompted to update the archive)

but now if i whant create new box i see

Table 'unisatdb3.smf_sp_functions' doesn't exist
Plik: /unisat/forum.kameralnie.com/Sources/Subs-PortalAdmin.php
Linia: 104

I install

[AngelinaBelle]

Now that the 2.3.3 package is available, the SimplePortal team recommends using SimplePortal 2.3.3
 
This may be the easiest solution to the problems.

[dex]

Now that the 2.3.3 package is available, the SimplePortal team recommends using SimplePortal 2.3.3
 
This may be the easiest solution to the problems.

yes i konow but i instal 2.3.3. whit this problem

1 update smf 2.3 to 2.4
2. uinstal SP
3. Instal new SP 2.3.3 with this problem

Now i cant create new block

Table 'unisatdb3.smf_sp_functions' doesn't exist
Plik: /unisat/forum.kameralnie.com/Sources/Subs-PortalAdmin.php
Linia: 104

[AngelinaBelle]

When you uninstalled SimplePortal, did you tell it to remove all the SimplePortal data as well?

[dex]

When you uninstalled SimplePortal, did you tell it to remove all the SimplePortal data as well?

no i dont know where are they

[AngelinaBelle]

That is a checkbox option at uninstall time.
If you check that box, then the Package Manager will remove the mod's tables from the database.
 
Now, when you install SimplePortal 2.3.3, it should create all the tables SimplePortal needs.
It is the install2.php script.
 
If the Package Manager completed the 2.3.3 install, it should have run the install2.php script.
But it sounds as though it did not do that. I do not know why this is.
 
To get those tables, you need to run install2.php or restore ONLY your SimplePortal tables from a recent backup.
 
I am splitting your posts into a new topic.  This may make it easier to find and answer your problem.

[dex]

how to start install2.php script I dont see in my ftp

[AngelinaBelle]

The package manager removes it after installation is complete.
But I am still surprised you are having this problem.
You are installing SimplePortal 2.3.3?