SMF Support > SMF 2.0.x Support

I would like some advice about database for 2.0

(1/1)

Anub1s:

--- Code: ---db_query("
ALTER TABLE {$db_prefix}members ADD COLUMN
CAMFROG VARCHAR(50) NOT NULL default '',
TYPE=MyISAM", __FILE__, __LINE__);

--- End code ---

i am having a problem with this query its not installing properly.

what should it be please. i have asked in the codeing talk section with no joy. fixed one problem but no help with the other :( somone please help :(  :(

karlbenson:
In SMF 2.x querying is completely different.
New functions need to be used (which was necessary to allow support for postgresql and sqlite).

See http://www.simplemachines.org/community/index.php?topic=224166.0

The one your after is $smcFunc['db_add_column']
http://www.simplemachines.org/community/index.php?topic=224166.0#post_db_add_column

Anub1s:
ok do replace db_prefix with $smcFunc['db_add_column'] then

just to say if anyone can just do a quick demo of wat i have to do i would be much apriciated. as i learn from seeing how its done :(

please and thankyou

metallica48423:
no, the $smfFunc['db_query'] would replace db_query.  theres i reccommend taking a look at SSI.php's database queries and reading the information on the queries over :).  it is different i know but as was mention it was necessary in order to properly support other database systems :)

Navigation

[0] Message Index