Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11845
Latest: SamoanOnion
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 42481
Total Topics: 7409
Most Online Today: 33
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 26
Total: 27

Author Topic: Database error  (Read 9192 times)

0 Members and 1 Guest are viewing this topic.

Offline Beltazar

  • Member
  • *
  • Posts: 22
    • View Profile
    • Dreamslayer Artworks
Database error
« on: February 23, 2009, 09:37:12 pm »
Ok.. I upgraded to the 1.3 store and I am running smf 1.1.8 forum, but now the products as I goto them..

Database Error
Unknown column 'checktext' in 'field list'
File: /home/dreamsla/public_html/forum/Sources/Store.php
Line: 5914

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.   

so where do I find and get this update..

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: Database error
« Reply #1 on: February 23, 2009, 09:49:01 pm »
Try running the following command on your SMF forum's database this is normally run when you install the upgrade.

Code: [Select]
ALTER TABLE smf_store_shippingconditions CHANGE `condition` checktext tinytext
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Beltazar

  • Member
  • *
  • Posts: 22
    • View Profile
    • Dreamslayer Artworks
Re: Database error
« Reply #2 on: February 23, 2009, 10:00:41 pm »
Not to sound really dumb.. but I am not the Database user.. so I need a bit more then that.. lol..

sorry..

and thanks in a advance..

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: Database error
« Reply #3 on: February 23, 2009, 10:19:25 pm »
This would be run on the database prompt for your smf forum.
You can use a tool such as phpMyAdmin normally built into the control panel to run this query on your forum's database
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Beltazar

  • Member
  • *
  • Posts: 22
    • View Profile
    • Dreamslayer Artworks
Re: Database error
« Reply #4 on: February 23, 2009, 10:34:44 pm »
ok.. did this query..  and still the same thing.. do I need to restart the database for it to take effect..


Code: [Select]
Error

SQL query:

ALTER TABLE smf_store_shippingconditions CHANGE `condition` checktext tinytext

MySQL said: Documentation
#1054 - Unknown column 'condition' in 'smf_store_shippingconditions'

This is what I get...

Code: [Select]
Error

SQL query:

ALTER TABLE smf_store_shippingconditions CHANGE `condition` checktext tinytext

MySQL said: Documentation
#1146 - Table 'dreamsla_dsv.smf_store_shippingconditions' doesn't exist





Database Error
Unknown column 'checktext' in 'field list'
File: /home/dreamsla/public_html/forum/Sources/Store.php
Line: 5914

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.
« Last Edit: February 23, 2009, 10:41:28 pm by Beltazar »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: Database error
« Reply #5 on: February 23, 2009, 11:14:20 pm »
Are you inside the database of the forum. 1st error looks ok second error not so much.

If you do not have any shipping conditions you can do the following
Code: [Select]
DROP TABLE smf_store_shippingconditions;
Then run
Code: [Select]
CREATE TABLE IF NOT EXISTS smf_store_shippingconditions(
ID_CONDITION int(11) NOT NULL auto_increment,
value1 double(10,2) NOT NULL default '0',
value2 double(10,2) NOT NULL default '0',
checktext tinytext,
percent  double(10,2) NOT NULL default '0',
totalamount double(10,2) NOT NULL default '0',
PRIMARY KEY  (ID_CONDITION))
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Beltazar

  • Member
  • *
  • Posts: 22
    • View Profile
    • Dreamslayer Artworks
Re: Database error
« Reply #6 on: February 23, 2009, 11:41:20 pm »
same issue..


ran query successfully..


Code: [Select]
Database Error
Unknown column 'checktext' in 'field list'
File: /home/dreamsla/public_html/forum/Sources/Store.php
Line: 5914

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.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: Database error
« Reply #7 on: February 24, 2009, 07:25:32 am »
Ran both queries? Is smf_ the prefix for your forum?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Beltazar

  • Member
  • *
  • Posts: 22
    • View Profile
    • Dreamslayer Artworks
Re: Database error
« Reply #8 on: February 24, 2009, 07:20:48 pm »
Fixed..     we believe it is fixed right..  hopefully..   until we put real physical stuff in the store, then maybe it will work maybe it will not.. LMAO..
Not entirely sure what has happened or exactly, cuz u database guys have a language of your own..  but something about where and what that error was, lead him to the Database and did something w/ a column.

Fix..
Code: [Select]
$result = db_query("
SELECT
percent, totalamount, value1, value2, ID_CONDITION
FROM {$db_prefix}store_shippingconditions", __FILE__, __LINE__);

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: Database error
« Reply #9 on: February 24, 2009, 07:54:07 pm »
That basically disables the shipping condition shipping system if you don't use it is is ok to do.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Beltazar

  • Member
  • *
  • Posts: 22
    • View Profile
    • Dreamslayer Artworks
Re: Database error
« Reply #10 on: February 24, 2009, 08:08:08 pm »
well at the moment, we do not ship anything real, but we will in the future sometime..

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
9897 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
3 Replies
5320 Views
Last post February 25, 2009, 11:52:00 pm
by Sweetwater
Database Error

Started by pioneer « 1 2 » Support

22 Replies
11640 Views
Last post April 18, 2009, 11:58:55 am
by SMFHacks
7 Replies
5851 Views
Last post June 11, 2009, 09:50:27 pm
by SMFHacks
4 Replies
4693 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

Delete old file by SMFHacks
October 05, 2022, 08:11:13 am

[Feature Request] Thumbnail on topic list by Shades
October 04, 2022, 11:40:26 am

Undefined index: class_ad_seller by SMFHacks
October 04, 2022, 09:33:36 am

"Custom title" badge by Hatshepsut
September 27, 2022, 10:11:27 pm

Category Selection by Anmer
September 18, 2022, 02:40:06 am

Setting a single free download. by Zaphod
September 12, 2022, 10:18:45 pm

Error message "Data too long for column 'ipaddress' at row 1" by SMFHacks
September 12, 2022, 08:49:02 am

SMF to SMF bridge via WP by SMFHacks
September 11, 2022, 09:44:30 am

Video player included by SMFHacks
September 06, 2022, 10:26:27 pm

Upload hangs / doesn't complete by SMFHacks
August 28, 2022, 08:36:21 am

Powered by EzPortal