Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11839
Latest: BugginIn
New This Month: 2
New This Week: 0
New Today: 0
Stats
Total Posts: 42423
Total Topics: 7395
Most Online Today: 159
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 113
Total: 113

Author Topic: Database error  (Read 9162 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: 16086
    • 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: 16086
    • 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: 16086
    • 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: 16086
    • 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: 16086
    • 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
9864 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
3 Replies
5232 Views
Last post February 25, 2009, 11:52:00 pm
by Sweetwater
Database Error

Started by pioneer « 1 2 » Support

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

+- Recent Topics

Custom badges by Hatshepsut
August 18, 2022, 10:10:46 pm

Membergroup level by davejo
August 18, 2022, 02:13:49 am

Setting a single free download. by SMFHacks
August 16, 2022, 09:50:04 am

Quick moderation checkboxes in search result? by SMFHacks
August 08, 2022, 10:37:03 am

Contact Page Mod Not Working by SMFHacks
August 05, 2022, 12:19:43 pm

Issues with new Newsletter Pro installation by SMFHacks
August 05, 2022, 07:15:18 am

SMFBlog Mod by Nicole
August 03, 2022, 09:46:22 pm

Contact Page by Nicole
August 03, 2022, 09:45:42 pm

trader + classifieds by Nicole
August 03, 2022, 05:05:17 pm

Category Permissions List by SMFHacks
July 30, 2022, 07:53:24 am

Powered by EzPortal