News:

Help keep this project going by donating or buying adseller pro

Main Menu
Coinbase

[SOLVED] Last Query Didn't Execute on Install

Started by devnet, April 25, 2007, 09:15:17 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

devnet

/*
Inserts into the settings table
*/
db_query("
INSERT IGNORE INTO {$db_prefix}settings
(variable, value)
VALUES ('ads_displayAdsAdmin', '0'),
('ads_updateReports', '0'),
('ads_quickDisable', '0'),
('ads_lookLikePosts', '1')", __FILE__, __LINE__);


How can I execute this so that it completes the install?  It's not working in webmin (I don't have phpmyadmin installed, nor will I).

Can anyone help me out?

bigguy

I have left this for Jerm as he will probably be able to help you out.

devnet

Thanks bigguy.

Installing these by hand is a trip.  This host we're on doesn't have ftp and won't allow ftp (firewall)...they only allow secure connections.  So we're stuck installing packages by hand.

I just couldn't get this last part to execute in the query browser :(

jerm

Sorry for the delay. Were you able to figure it out?

devnet

Not yet...but I'm thinking of getting it installed on another one of my accounts and then exporting the database with a drop table statement and then uploading it to this host.

It should (since it's going to be a vanilla smfad install) work.

devnet

jerm,

I'm unable to get this to work...I need a straight .sql file for the manual install.  I can make the edits inside the php no problem but trying to get the database to get the right entries is killing me.

Do you have a .sql you could post that would help me?

jerm

The SQL is in the install.php file. You just need to follow that.
For example: {$db_prefix} would be replaced by smf_ or whatever you set it to..

devnet

Ok jerm


Got it fixed...thanks for pointing me in the right direction.  I have a different problem but I'll post that in a different thread and mark this one solved :)