TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

April 18, 2024, 01:03:54 AM

Login with username, password and session length
Members
  • Total Members: 3,885
  • Latest: Growner
Stats
  • Total Posts: 195,164
  • Total Topics: 21,219
  • Online today: 143
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 131
  • Total: 131

TP 0.983 on SMF 1.1.2: MySQL Error

Started by Questwizard88, April 15, 2007, 01:41:03 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Questwizard88

OK. I installed SMF 1.1.1 this morning, then installed the 1.1.2 update package. Everything on the forums is working correctly, except for installing TinyPortal 0.983 on it. I grabbed the full install package, uploaded it to the forum, then headed on over to the Package Manager to install it. When I clicked Apply Mod, it ran all the tests, and everything checked out just fine, like this:

Installations actions for "TinyPortal":
Installing this package will perform the following actions:
Type Action Description
1. Extract Tree ./Themes
2. Extract Tree ./Sources
3. Extract Tree ./tp-downloads
4. Extract Tree ./tp-images
5. Extract Tree ./FCKeditor
6. Extract Tree ./wysiwyg
7. Execute Code tp_install.php
8. Execute Modification ./index.php Test successful
9. Execute Modification ./Sources/Load.php Test successful
10. Execute Modification ./Themes/default/index.template.php Test successful
11. Execute Modification ./Themes/babylon/index.template.php Test successful
12. Execute Modification ./Sources/Subs.php Test successful
13. Execute Modification ./Sources/ManagePermissions.php Test successful
14. Execute Modification ./Sources/Security.php Test successful
15. Execute Modification ./Sources/Errors.php Test successful
16. Execute Modification ./Themes/default/style.css Test successful
17. Execute Modification ./Themes/default/Help.template.php Test successful
18. Execute Modification ./Sources/Profile.php Test successful
19. Execute Modification ./SSI.php Test successful

However, when I clicked Install Now, this is what happens:

Commands 1-6 run just fine, as all the files were extracted to their correct paths and everything.
Once command 7 (the installer) ran, I waited for about 30 seconds while it did its work, only to get the following error:


# Upshrink table created
# Settings table created
2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
File: /home/content/q/u/e/questwizard88/html/Packages/temp/tp_install.php
Line: 169


i contacted my host's technical support, and they're puzzled with it. I even tried uninstalling the 1.1.2 update and downgrading the forum back to 1.1.1, and tried installing TP 0.971, only to get the exact same error.

The forum is located at http://www.questwizard.net

Does anyone know why it might be giving me this error?

G6Cad

Download the BIG upgrade package from SMF and take the 2 sql files out from the package and also the upgrade.php
Point the browser to the upgrade.php and update the SMF tables.
Then set your forum to the SMF DEFAULT CORE theme and install TP again.

Questwizard88

That did the trick. I guess those update packages from the package manager don't like updating the database too much.


Thanks for the help.