SMFHacks.com
** Home Forum Index Hacks Products Login Register Search
Welcome, Guest. Please login or register.
May 24, 2012, 07:07:47 am

Login with username, password and session length
Members
Total Members: 10071
Latest: cdavidson012
Stats
Total Posts: 28686
Total Topics: 4977
Online Today: 55
Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Users: 2
Guests: 50
Total: 52
+ 
|-+ 
| |-+ 
| | |-+ 
| | | |-+ 
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] 2 Go Down Print
Author Topic: Upgrading Error...  (Read 5224 times)
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« on: February 28, 2009, 11:29:38 am »

I am getting the following error when upgrading the store...

Quote
It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.8, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.


Can't seem to find a 1.1.6 reference in any of the PHP files?

Anyone have anything on this?

Also it seems that although the mod did not "apply"...  Some of the new features did indeed install...  AND, i am no longer able to access store transactions detail that came prior to the update!

« Last Edit: February 28, 2009, 06:35:12 pm by rhacker382 » Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #1 on: February 28, 2009, 12:08:59 pm »

ok just looked at the store PHP file and it says version 1.3???

but the package installer says it could not apply the mod?

also  getiing this error over and over:

8: Undefined variable: modSettings
File: ...membersforum/Sources/Store.php
Line: 5971
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #2 on: February 28, 2009, 12:20:02 pm »

All kinds of odd things happening...

"Downloading Transaction" feature only downloads transactions prior to the upgrade attempt!

This is very disturbing.
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #3 on: February 28, 2009, 12:30:39 pm »

Some screen captures:
« Last Edit: February 28, 2009, 01:01:19 pm by rhacker382 » Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #4 on: February 28, 2009, 05:06:59 pm »

1. I would need to see the error from the error log to get a better understanding of what happened.

2. Post #2 has been fixed for the next update.
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #5 on: February 28, 2009, 05:21:31 pm »

Here you go... See attachment...

How can we get this back to the older version?  I can't do an uninstall...? The version on the package installer doesn't match the version in the store itself...

The download transactions feature is very important... 

We had to re input a number of products into the store...

All the drop down boxes for products had to be re-done...

Etc etc...

There seem to be a number of bugs...   Embarrassed
« Last Edit: February 28, 2009, 06:33:24 pm by rhacker382 » Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #6 on: February 28, 2009, 05:26:21 pm »

I can't recreate the download transaction issue on my test forum I was able to download transactions since the beginning.

The package manager version looks ok to me they all say 1.3

You can try grabbing an older version of the store from the package manager. i can reposted older versions of the store as well once I get back to my main pc.

The attachmetn posted is just the $modSettings issue and does contain information about the first issue.

Kind of hard to test things when you have very limited amount of testers.  I did post preview versions for users to test
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #7 on: February 28, 2009, 05:48:34 pm »

The installation did not complete...  Yet it says I have 1.3...

If I click on the older transactions "transaction detail" I get:

Quote
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 4
File: /home/content/r/h/a/[DataBaseName]/html/membersforum/Sources/Load.php(1729) : eval()'d code
Line: 7319

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.8, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

And it reset all the old order numbers to "0"...

I am at a complete loss here...



« Last Edit: February 28, 2009, 05:54:56 pm by rhacker382 » Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #8 on: February 28, 2009, 06:03:35 pm »

I would try to run the upgrade again delete 1.3 then reapply the upgrade package. I need the exact error message on upgrade.
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #9 on: February 28, 2009, 06:12:39 pm »

Ah ok...  Downloading Transactions did work for recent purchases made today...  I just had to search through tomorrows date - which makes sense as today is not over yet.

Now if we can get the package installer to read correctly and my transaction details back for the earlier transactions to make my storekeeper happy I might be out of the woods..
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #10 on: February 28, 2009, 06:21:50 pm »

the exact install error was:

Quote
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 78,'Black')' at line 3
File: /home/content/r/h/a/[DatabaseName]/html/membersforum/Packages/temp/storeinstall.php
Line: 934

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.8, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #11 on: February 28, 2009, 06:31:49 pm »

in the packages/temp file there is "Store2.php" as well as duplicates for all the other php files...  is this normal?
Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #12 on: February 28, 2009, 06:39:19 pm »

Store2.php you can ignore. It is for SMF 2.0.x support.

Thanks for the error report will check it out now.
Logged
SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 9678


View Profile
« Reply #13 on: February 28, 2009, 07:13:01 pm »

Released an update mostly fixes.

Version 1.3.1
!Fixed database error when giving a free product to a user
!Fixed issue deleting a select field value
!Fixed missing shopping cart tab issue missing global variable $modSettings
+Added option to import select field items from other products on the manage select page
!Fixed a couple of undefined errors on the print view page in SMF 1.1.x
!Fixed an upgrade issue with custom fields
!Fixed simple permission text display in SMF 2.0.x
Logged
rhacker382
SMF Store Customer
Newbie
*****
Offline Offline

Posts: 25


View Profile
« Reply #14 on: March 03, 2009, 09:14:31 am »

New update did take with no problems...
 
Still have the same issue witht the old trasaction details being unavailable.  Have to download them to access the information.
Logged
Pages: [1] 2 Go Up Print 
« previous next »
Jump to:  

Recent
[Today at 04:11:41 am]

[Today at 12:16:16 am]

[May 21, 2012, 08:54:11 am]

[May 20, 2012, 11:06:52 am]

[May 20, 2012, 05:58:11 am]

[May 19, 2012, 06:16:58 pm]

[May 19, 2012, 05:42:37 pm]

[May 18, 2012, 03:08:38 pm]

[May 17, 2012, 06:07:46 pm]

[May 17, 2012, 02:22:07 pm]
Random Picture
Donate to SMFHacks.com
Help Support the SMFHacks.com mod making.
Powered by SMF 1.1.16 | SMF © 2006-2011, Simple Machines LLC
TinyPortal v0.9.7 © Bloc
SMF and SimpleMachines are registered trademarks of Simple Machines. SMFHacks.com is not affiliated with nor endorsed by Simple Machines.
Page created in 0.266 seconds with 19 queries.