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

Recent

Welcome to TinyPortal. Please login or sign up.

March 29, 2024, 05:19:20 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,105
  • Total Topics: 21,213
  • Online today: 310
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 255
  • Total: 255

Installation problem while extracting. Database error

Started by TimUSA, February 11, 2012, 05:54:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

TimUSA

Link to my site: http://vsk-ayc.com
SMF version: SMF 2.02
TP version: TP 1.105
Default Forum Language: English
Theme name and version: Default Theme
Browser Name and Version: Chrome
Mods installed: No Mods Installed
Related Error messages: Database Error
Invalid default value for 'pos'
File: /home/www/vsk-ayc.com/Packages/temp/SMF2/tp_upgrade.php
Line: 317



I am attempting to install TP 1.105 on porting my site to a new server and upgrading my SMF version to 2.02.

at:
http://vsk-ayc.com/index.php?action=admin;area=packages;sa=install;package=TinyPortal10_rc3.zip

all going well so far!
1. Extract Tree ./Themes
2. Extract Tree ./Themes
3. Extract Tree ./Sources
4. Extract Tree ./tp-downloads
5. Extract Tree ./tp-images
6. Extract Tree ./tp-files
7. Execute Modification ./index.php Test successful
1. Add After ./index.php Test successful
2. Add Before ./index.php Test successful
3. Replace ./index.php Test successful
4. Add After ./index.php Test successful
8. Execute Modification ./Sources/Load.php Test successful
1. Add After ./Sources/Load.php Test successful
2. Replace ./Sources/Load.php Test successful
3. Replace ./Sources/Load.php Test successful
4. Add After ./Sources/Load.php Test successful
9. Execute Modification ./Sources/Subs.php Test successful
1. Add Before ./Sources/Subs.php Test successful
2. Add After ./Sources/Subs.php Test successful
3. Add Before ./Sources/Subs.php Test successful
4. Add After ./Sources/Subs.php Test successful
5. Add Before ./Sources/Subs.php Test successful
6. Replace ./Sources/Subs.php Test successful
7. Add Before ./Sources/Subs.php Test successful
10. Execute Modification ./Sources/Security.php Test successful
1. Add After ./Sources/Security.php Test successful
11. Execute Modification ./Sources/Errors.php Test successful
1. Add After ./Sources/Errors.php Test successful
12. Execute Modification ./SSI.php Test successful
1. Add After ./SSI.php Test successful
13. Execute Modification ./Sources/QueryString.php Test successful
1. Add Before ./Sources/QueryString.php Test successful
2. Replace ./Sources/QueryString.php Test successful
14. Execute Modification ./Sources/Subs-Editor.php Test successful
1. Replace ./Sources/Subs-Editor.php Test successful
15. Execute Modification ./Sources/Profile.php Test successful
1. Add Before ./Sources/Profile.php Test successful
16. Adapt Database SMF2/tp_upgrade.php


then at:
http://vsk-ayc.com/index.php?action=admin;area=packages;sa=install2;package=TinyPortal10_rc3.zip;pid=0

I receive the following error and cannot complete the installation.
Database Error
Invalid default value for 'pos'
File: /home/www/vsk-ayc.com/Packages/temp/SMF2/tp_upgrade.php
Line: 317

G6Cad

Why the upgrade verision of TP when you say you run all fresh  at first, and later down the post you say you upgrade your SMF verision ?

If you are moving your forum to another server you should first export/import the db from the old server, Then upgrade ( prefer to use the full SMF install package instead of old files ) the DB from the new SMF package,

When everything runs as it should with SMF only, THEN install TP with the FULL package, and not the upgrade.

IchBin

Sounds like your mysql version may be running in strict mode or something. Check with your host, as I think it's trying to tell you that the value for the pos row in the table needs to have a certain default set in it. When it shouldn't need this. Disabling strict mode in mysql will probably solve it.

G6, the tp_upgrade.php file is used for both install on new and upgrades. Maybe that is what you are seeing?

TimUSA

it would appear that my host does not allow me to turn off strict mode. am i to assume that a manual install would be my next step?

G6Cad


IchBin

I don't think manual install will be any better if your host is restricting mysql in such a way. Running the tp_upgrade.php file through the package manager or manually will probably have the same problem. Let me know if it works.

TimUSA

ok this in fact is not a problem with strict mode on MYSQL as I was able to build a clean install in another directory/database.

so at this point i am completely stumped.

I dont think a manual install will help at this point.

Is it possible to just copying the files and importing the database from my working instance over to the sit i am attempting to get running again?

IchBin

Yes you could do that, but you will also need to make all the file edits that TP does to the SMF files assuming you replaced all your files in the SMF upgrade.