Database error

[Beltazar]

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..

[SMFHacks]

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


[Beltazar]

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..

[SMFHacks]

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

[Beltazar]

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.

[SMFHacks]

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))


[Beltazar]

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.

[SMFHacks]

Ran both queries? Is smf_ the prefix for your forum?

[Beltazar]

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__);

[SMFHacks]

That basically disables the shipping condition shipping system if you don't use it is is ok to do.

[Beltazar]

well at the moment, we do not ship anything real, but we will in the future sometime..