Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12389
Latest: GhostHunting
New This Month: 6
New This Week: 1
New Today: 1
Stats
Total Posts: 40330
Total Topics: 7100
Most Online Today: 83
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 38
Total: 38

Author Topic: Database error  (Read 8690 times)

0 Members and 1 Guest are viewing this topic.

Offline Beltazar

  • Newbie
  • *
  • 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: 15159
    • 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

  • Newbie
  • *
  • 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: 15159
    • 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

  • Newbie
  • *
  • 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: 15159
    • 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

  • Newbie
  • *
  • 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: 15159
    • 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

  • Newbie
  • *
  • 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: 15159
    • 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

  • Newbie
  • *
  • 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
8350 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
3 Replies
4694 Views
Last post February 25, 2009, 11:52:00 pm
by Sweetwater
Database Error

Started by pioneer « 1 2 » Support

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

+- Recent Topics

prettyurls - TroubleShooting.wiki by SMFHacks
Today at 04:24:47 pm

Quality of images after import by SMFHacks
September 05, 2020, 10:21:44 am

How do I download gallery images? by CWVRV
August 30, 2020, 11:50:07 pm

Deleting Empty Galleries by SMFHacks
August 30, 2020, 11:43:32 am

PHP error by davejo
August 25, 2020, 07:35:13 am

Permissions to list ads and buy items by CWVRV
August 21, 2020, 05:19:45 pm

Doubt with download permissions. by Rock Lee
August 20, 2020, 08:23:24 pm

Attachment images Upsidedown or Sideways by SMFHacks
August 18, 2020, 05:41:07 pm

[Mod]Avatars Display Integration by Hatshepsut
August 17, 2020, 11:39:54 pm

Simple Portal Block - Classifieds by SMFHacks
August 16, 2020, 09:56:48 am

Powered by EzPortal