Codezwiz >> Forums >> General PHP Nuke Help >> manually pulling SQL from install files that won't install

The mod in question in this care is the Restrict images in signatures mod ported by telli.

I can't get the install to run. But I'm wondering, if I pulled the following from the install coding, can I just quesry my DB with it to achieve the installation?

"INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ('sig_images_max_width', 400), ('sig_images_max_height', 300), ('sig_images_max_limit', 1)";

This was the only SQL command I saw, but I will post the rest of the file here:

<?php
/***************************************************************************
* db_update.php
* -------------------
* copyright : �2003 Freakin' Booty ;-P
* built for : Restrict images in signatures 0.1.1
*
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/

if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}
if ($popup != "1"){
$module_name = basename(dirname(__FILE__));
require("modules/".$module_name."/nukebb.php");
}
else
{
$phpbb_root_path = 'modules/Forums/';
}

define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX, $nukeuser);
init_userprefs($userdata);
//
// End session management
//

$page_title = 'Updating the database';
include('includes/page_header.php');

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><ul type="circle">';

$sql = array();
$sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ('sig_images_max_width', 400), ('sig_images_max_height', 300), ('sig_images_max_limit', 1)";

for( $i = 0; $i < count($sql); $i++ )
{
if( !$result = $db->sql_query ($sql[$i]) )
{
$error = $db->sql_error();

echo '<li>' . $sql[$i] . ' +++ Error: ' . $error['message'] . '</li> ';
}
else
{
echo '<li>' . $sql[$i] . ' +++ Successfull</li> ';
}
}

echo '</ul></td></tr><tr><td class="catBottom" height="28"> ;;</td></tr>';
echo '<tr><th>End</th></tr><tr><td>Installation is now finished. Please be sure to delete this file now. If you have run into any errors, please visit the <a href="http://www.codezwiz.com/forums.html" target="_blank">codezwiz.com support forums</a> and ask someone for help.</td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></td></table>';

include('includes/page_tail.php');

?>

Thanks for any help on this,

Sabastina

Did you upload the file to your modules/forums directory and then try to access that file from your browser? IE...www.mysite.com/modules.php?name=Forums&file=db_update

If you still can't get it to run, you should be able to put the following into the SQL box in phpMyAdmin

INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ('sig_images_max_width', 400), ('sig_images_max_height', 300), ('sig_images_max_limit', 1)

" . CONFIG_TABLE. " is a defined constant. If you want to use it phpmyadmin change that too nuke_bbconfig.

INSERT INTO nuke_bbconfig (config_name, config_value) VALUES ('sig_images_max_width', 400), ('sig_images_max_height', 300), ('sig_images_max_limit', 1);

Ok, I may have found an answer to the problem.
When I entered it manually, I got the following

Database wisdomofthedark_org_-_phpnuke1 running on localhost
Error

SQL-query :

"INSERT INTO ". CONFIG_TABLE . " (config_name, config_value) VALUES ('sig_images_max_width', 400), ('sig_images_max_height', 300), ('sig_images_max_limit', 1)"

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"INSERT INTO " . NUKE_CONFIG . " (config_name, config_value) VA

At first I thought it was because my table is called NUKE_CONFIG umm...that didn't work and so I decided to come here and pose the question, what is the error and where is this manual?

Thanks for reading!

Sabastina

It worked! Thanks guys!

U ROCK!

Sabastina