SMF Support > PostgreSQL and SQLite Support

SQLite In Smf

(1/4) > >>

niires1204:
hello guys,

actually i created my smf forum with Db type as SQLite.well i wanted to install a few mods, but in those mods i have to create db tables.
well where can i find the SQLite db inside the root folder of forum??
 
the db queries are

The 3 queries i want to run is


--- Code: ---
CREATE TABLE IF NOT EXISTS {db_prefix}log_enotify_pms (
id_enot mediumint(8) NOT NULL auto_increment,
enot_item_id mediumint(8) NOT NULL,
enot_title varchar(255) NOT NULL,
enot_time int(10) NOT NULL,
enot_link tinytext NOT NULL,
enot_sender varchar(255) NOT NULL,
enot_sender_link text NOT NULL,
id_member mediumint(8) NOT NULL,
enot_read tinyint(3) NOT NULL default '0

--- End code ---



query 2 :

--- Code: ---CREATE TABLE IF NOT EXISTS {db_prefix}log_enotify_replies (
id_enot mediumint(8) NOT NULL auto_increment,
enot_item_id mediumint(8) NOT NULL,
enot_title varchar(255) NOT NULL,
enot_time int(10) NOT NULL,
enot_link tinytext NOT NULL,
enot_sender varchar(255) NOT NULL,
enot_sender_link text NOT NULL,
id_member mediumint(8) NOT NULL,
enot_read tinyint(3) NOT NULL default '0

--- End code ---

3rd query

--- Code: ---INSERT IGNORE INTO {db_prefix}settings
(variable, value)
VALUES ('enotify_life', '5000'),
('enotify_refresh', '10000'),
('enotify_pms', '1'),
('enotify_replies', '1'),
('enotify_exp','48');

--- End code ---


please dont give me the plain php script. can you insert the queryt inside the php script so that i can Just run it inside my host directories.

emanuele:
Hi,

sorry for the late reply.

Please try the attached file, put it in your forum's directory (it must be in the same directory as SSI.php) and the point to it with your browser, e.g.:

--- Code: ---http://www.yourwebsite.tld/forum/installScript.php
--- End code ---
if nothing goes wrong you will obtain an empty page (sorry, I used one of my mods install script...it's not very informative).

It should work, in case you have any problem feel free to ask! :)

BTW, if the mod doesn't even have a proper install script for 2.0 (by the query you posted it seems a SMF 1.x mod) maybe it will not work at all with SQLite...
What mod is it?

niires1204:
hey the script doesnot work which you gave me :

screen shot :







and the 2 mods which i tried to install:
http://custom.simplemachines.org/mods/index.php?mod=2198
http://custom.simplemachines.org/mods/index.php?mod=2543

niires1204:
your scripts gives an anoyomus error lol.. so can you plzzz help me personally  my msn  niires1204@live.in

Oldiesmann:
What errors do you get if you try the one that emanuele gave you?

Navigation

[0] Message Index

[#] Next page

Go to full version