Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 193
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 191
Total: 191

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

Started by pioneer « 1 2 » Support

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

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal