Coinbase

Author Topic: [SOLVED] Last Query Didn't Execute on Install  (Read 3875 times)

0 Members and 1 Guest are viewing this topic.

Offline devnet

  • Jr. Member
  • **
  • Posts: 23
    • Email
[SOLVED] Last Query Didn't Execute on Install
« on: April 25, 2007, 08:15:17 pm »
Code: [Select]
/*
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?
« Last Edit: May 08, 2007, 08:46:04 am by devnet »

Offline bigguy

  • Support
  • Elite Member
  • *
  • Posts: 1518
    • SMF Helper
Re: Last Query Didn't Execute on Install
« Reply #1 on: April 26, 2007, 07:17:14 am »
I have left this for Jerm as he will probably be able to help you out.

Offline devnet

  • Jr. Member
  • **
  • Posts: 23
    • Email
Re: Last Query Didn't Execute on Install
« Reply #2 on: May 03, 2007, 05:58:09 pm »
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 :(

Offline jerm

  • Support
  • Elite Member
  • *
  • Posts: 726
Re: Last Query Didn't Execute on Install
« Reply #3 on: May 06, 2007, 03:46:25 pm »
Sorry for the delay. Were you able to figure it out?

Offline devnet

  • Jr. Member
  • **
  • Posts: 23
    • Email
Re: Last Query Didn't Execute on Install
« Reply #4 on: May 06, 2007, 08:37:08 pm »
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.

Offline devnet

  • Jr. Member
  • **
  • Posts: 23
    • Email
Re: Last Query Didn't Execute on Install
« Reply #5 on: May 07, 2007, 11:27:48 am »
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?

Offline jerm

  • Support
  • Elite Member
  • *
  • Posts: 726
Re: Last Query Didn't Execute on Install
« Reply #6 on: May 07, 2007, 08:26:40 pm »
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..

Offline devnet

  • Jr. Member
  • **
  • Posts: 23
    • Email
Re: Last Query Didn't Execute on Install
« Reply #7 on: May 08, 2007, 08:45:35 am »
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 :)

SMF Ads Support Forum

Re: Last Query Didn't Execute on Install
« Reply #7 on: May 08, 2007, 08:45:35 am »
.