SimplePortal

Support => Install and Upgrade => Topic started by: dex on November 05, 2010, 10:17:23 AM

Title: SimplePortal tables missing after upgrade/uninstall
Post by: dex on November 05, 2010, 10:17:23 AM
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

Quote
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

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

I install
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: AngelinaBelle on November 05, 2010, 10:26:53 AM
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.
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: dex on November 05, 2010, 10:30:36 AM
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

Quote
Table 'unisatdb3.smf_sp_functions' doesn't exist
Plik: /unisat/forum.kameralnie.com/Sources/Subs-PortalAdmin.php
Linia: 104
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: AngelinaBelle on November 05, 2010, 11:49:00 AM
When you uninstalled SimplePortal, did you tell it to remove all the SimplePortal data as well?
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: dex on November 05, 2010, 12:03:17 PM
When you uninstalled SimplePortal, did you tell it to remove all the SimplePortal data as well?

no i dont know where are they
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: AngelinaBelle on November 05, 2010, 12:15:42 PM
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.
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: dex on November 05, 2010, 01:03:07 PM
how to start install2.php script I dont see in my ftp
Title: Re: SimplePortal tables missing after upgrade/uninstall
Post by: AngelinaBelle on November 05, 2010, 01:21:54 PM
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?
SimplePortal 2.3.8 © 2008-2024, SimplePortal