| Please help! lol! | |
Posted: 01/10/2009 2:39 AM |
|
|
|
|
Sparrow |
Posts |
11 |
Word Cnt. |
2,995 |
BDay |
N/A |
Sign |
N/A |
|
|
|
|
|
Joined: Jan 10, 2009
Local time: 1:53 AM
|
|
|
|
|
|
Code:
|
Parse error: syntax error, unexpected T_STRING in /home/mydavvie/public_html/nulavatar_install.php on line 184
|
What does it means?
And i am new! |
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/10/2009 2:55 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:53 AM
Location: St Pete, FL
|
|
|
|
|
|
Hi Angelface777,
Could you zip up your nulavatar_install.php file and provide a link to it so that I can download and review it for you? If that is too much trouble, you could post the lines of text from the file starting from around line 175-195. If you have not modified this file, you could point me to where you got it so that I can download and look at it...
I currently have a copy of Nulavatar version 1.3.0. Is that the version you are attempting to install???
Welcome to RCF Angelface777 !!!
Welcome to RCF Angelface777 !!!
|
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/13/2009 6:08 PM |
|
|
|
|
Sparrow |
Posts |
11 |
Word Cnt. |
2,995 |
BDay |
N/A |
Sign |
N/A |
|
|
|
|
|
Joined: Jan 10, 2009
Local time: 1:53 AM
|
|
|
|
|
|
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/13/2009 11:54 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:53 AM
Location: St Pete, FL
|
|
|
|
|
|
I don't see anything wrong in the file that you gave me. In fact, I was able to upload it to our vanilla board and run it. If there was a syntax error in it, I wouldn't have been able to run it. I should have seen the same error message that you are seeing. So I suspect that the nulavatar_install.php file on your server is corrupt. Try re-uploading this file to your phpBB forum folder and try it again. If you see the same problem, try clearing the cache for your site in your browser. Let me know if that corrects the problem...
|
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/14/2009 12:26 AM |
|
|
|
|
Sparrow |
Posts |
11 |
Word Cnt. |
2,995 |
BDay |
N/A |
Sign |
N/A |
|
|
|
|
|
Joined: Jan 10, 2009
Local time: 1:53 AM
|
|
|
|
|
|
Quote:
|
NulAvatar 1.3.1 Installer!
Check if phpbb_nulmods table exists...NO
Creating phpbb_nulmods table... COMPLETED
Inserting NulAvatar info... COMPLETED
Creating table "nulavatar_settings"... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Altering Settings table... COMPLETED
Altering Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Creating "nulavatar_layers" table... FAILED
Error Message:Invalid default value for 'dontshowlayer'
Creating "nulavatar_images" table... COMPLETED
Creating "nulavatar_userchars" table... FAILED
Error Message:Invalid default value for 'user'
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Checking if NulAvatar is able to write to ./images/nulavatar_avatars/... YES
Finished!
|
I was messing with my cashmod and i got this?
(Admin side)
Quote:
|
phpBB : Critical Error
Could not update user table
DEBUG MODE
SQL Error : 1091 Can't DROP 'user_points'; check that column/key exists
Array
Line : 203
File : cash_currencies.php
|
and when i go to viewtopic.php it says:
Quote:
|
General Error
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.user_points' in 'field list'
SELECT u.username, u.user_points, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 1 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 405
File : viewtopic.php
|
|
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/14/2009 12:49 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:53 AM
Location: St Pete, FL
|
|
|
|
|
|
Angelface777 wrote:
|
Quote:
|
NulAvatar 1.3.1 Installer!
Check if phpbb_nulmods table exists...NO
Creating phpbb_nulmods table... COMPLETED
Inserting NulAvatar info... COMPLETED
Creating table "nulavatar_settings"... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Altering Settings table... COMPLETED
Altering Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Creating "nulavatar_layers" table... FAILED
Error Message:Invalid default value for 'dontshowlayer'
Creating "nulavatar_images" table... COMPLETED
Creating "nulavatar_userchars" table... FAILED
Error Message:Invalid default value for 'user'
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Updating Settings table... COMPLETED
Checking if NulAvatar is able to write to ./images/nulavatar_avatars/... YES
Finished!
|
|
Ok, you're almost there. The author of this file made a couple of small mistakes that seems to work fine on some servers but not all. So to get this to work correctly on your server, make the following changes to the nulavatar_install.php file:
OPEN
nulavatar_install.php
FIND
Code:
|
`dontshowlayer` int(10) NOT NULL default '',
|
REPLACE WITH
Code:
|
`dontshowlayer` int(10) NOT NULL default '0',
|
FIND
Code:
|
`user` int(10) unsigned NOT NULL default '',
|
REPLACE WITH
Code:
|
`user` int(10) unsigned NOT NULL default '0',
|
Save, upload, and try again...
Notice that he was trying to assign a blank text character to an integer field in both examples above...
Angelface777 wrote:
|
I was messing with my cashmod and i got this?
(Admin side)
Quote:
|
phpBB : Critical Error
Could not update user table
DEBUG MODE
SQL Error : 1091 Can't DROP 'user_points'; check that column/key exists
Array
Line : 203
File : cash_currencies.php
|
|
You would expect to see this error if the user_points field does not exist in the phpbb_users table...
Angelface777 wrote:
|
and when i go to viewtopic.php it says:
Quote:
|
General Error
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.user_points' in 'field list'
SELECT u.username, u.user_points, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 1 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 405
File : viewtopic.php
|
|
And this error would also be caused if the user_points field didn't exist in the phpbb_users table. You need to create it in order for this to work. You can upload this and run it to create the user_points field though...
User_Points_DB_Update.zip
You will have to extract the file and upload the extracted file to your server. Then run it just like you did with the nulavatar_install.php file above...
|
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/14/2009 1:17 AM |
|
|
|
|
Sparrow |
Posts |
11 |
Word Cnt. |
2,995 |
BDay |
N/A |
Sign |
N/A |
|
|
|
|
|
Joined: Jan 10, 2009
Local time: 1:53 AM
|
|
|
|
|
|
Its not there! the
Code:
|
`dontshowlayer` int(10) NOT NULL default '',
|
and etc!
Code:
|
<?php
/********************************************************************* ******
* nulavatar_update.php
* -----------------------
* Update file
*
* NulAvatar made and (c) by Guido "Nuladion" Kessels
********************************************************************* ******/
define('IN_PHPBB', true);
$phpbb_root_path='./';
include($phpbb_root_path.'extension.inc');
include($phpbb_root_path.'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
$file = "nulavatar_install.php";
$na_version = "1.3.1";
if( !$userdata['session_logged_in'] )
{
header('Location: ' . append_sid("login.$phpEx?redirect=".$file, true));
}
if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
}
if( !strstr($dbms, "mysql") )
{
if( !isset($_GET['bypass']) )
{
$message = 'This mod has only been tested on MySQL and may only work on MySQL.<br />';
$message .= 'Click <a href="'.$file.'?bypass=true">here</a> to install anyways.';
message_die(GENERAL_MESSAGE, $message);
}
}
if($_GET['gdcheck'] != "ok")
{
$info = gd_info();
$keys = array_keys($info);
$values = array_values($info);
$checked = false;
echo "<b>NulAvatar ".$na_version." GDLibrary check!</b> <br />";
echo "<br />";
if(!$values[0]) {
echo("
You don't seem to have the <b>GD Library</b> installed on your server! <br />
The GD Library <i>is</i> required to use NulAvatar!<br />
<br />
Click <a href=\"".$file."?gdcheck=ok\">here</a> if you want to update NulAvatar anyway (not recommended)
");
$checked = true;
}
if(!$values[7]) {
if(!$values[4]) {
echo("
You have the GD Library installed, but don't seem to have <b>PNG Support</b> enabled on your server! <br />
The GD Library with PNG Support <i>is</i> required to use NulAvatar!<br />
<br />
Click <a href=\"".$file."?gdcheck=ok\">here</a> if you want to update NulAvatar anyway (not recommended)
");
$checked = true;
}
else {
echo("
You have the GD Library installed, but don't seem to have <b>PNG Support</b> enabled on your server! <br />
However, you seem to have GIF Read Support enabled!<br />
Make sure you set the NulAvatar 'Imagetype' to 'GIF' in the Settings Admin panel, and use GIF images instead of PNG!
<br />
Click <a href=\"".$file."?gdcheck=ok\">here</a> to update NulAvatar
");
$checked = true;
}
}
if(($values[4]) && ($values[7])) {
echo("
You have the GD Library installed with PNG Support and GIF Read Support enabled!<br />
This means you can use both PNG and GIF images with NulAvatar! <br />
Make sure to correctly change the NulAvatar 'Imagetype' in the Settings Admin panel if you switch from one image format to another! <br />
<br />
Click <a href=\"".$file."?gdcheck=ok\">here</a> to update NulAvatar
");
$checked = true;
}
if($checked == false)
{
echo("
The script failed to check your GD Library status...<br />
If you think you have the GD Library installed with 'PNG Support' and/or 'GIF Read Support' enabled,
you can still install NulAvatar. If you're not sure, I recommend you contact your host first! <br />
<br />
Click <a href=\"".$file."?gdcheck=ok\">here</a> to update NulAvatar
");
}
}
else
{
echo "<html>\n";
echo "<body>\n";
$sql = array();
$dat = array();
echo "<b>NulAvatar ".$na_version." Installer!</b> <br /><br />";
// Check if xxx_nulmods already exist!
echo "Check if ".$table_prefix."nulmods table exists...";
$check = mysql_query("SELECT * FROM ".$table_prefix."nulmods LIMIT 0,1");
if($check) {
// Table exists! -- Check if NulAvatar entry exists yet!
echo "<b><font color=\"007700\">YES</font></b><br />\n";
echo "Check for NulAvatar entry...";
$check2 = mysql_query("SELECT * FROM ".$table_prefix."nulmods WHERE title='NulAvatar' LIMIT 0,1");
$count2= mysql_num_rows($check2);
if($count2 > 0) {
// Found! -- Update NA version number!
echo "<b>found!</b> ";
$dat[] = "Updating version number";
$sql[] = "UPDATE `".$table_prefix."nulmods` SET version = '".$na_version."' WHERE title = 'NulAvatar'";
} else {
// Not found! -- Insert NulAvatar to nulmods table!
echo "<b>not found!</b> ";
$dat[] = "Inserting NulAvatar info";
$sql[] = "INSERT INTO `".$table_prefix."nulmods` (title,version) VALUES ('NulAvatar','".$na_version."')";
}
}
else {
// Table doesn't exist! -- Create it and add NulAvatar info!
echo "<b><font color=\"orange\">NO</font></b><br />\n";
$dat[] = "Creating ".$table_prefix."nulmods table";
$sql[] = "CREATE TABLE `".$table_prefix."nulmods` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` MEDIUMTEXT NOT NULL,
`version` MEDIUMTEXT NOT NULL,
PRIMARY KEY (`id`)
)";
$dat[] = "Inserting NulAvatar info";
$sql[] = "INSERT INTO `".$table_prefix."nulmods` (title,version) VALUES ('NulAvatar','".$na_version."')";
}
$sql[] = "CREATE TABLE `".$table_prefix."nulavatar_settings`
`config_id` int(10) unsigned NOT NULL auto_increment,
`config_name` MEDIUMTEXT NOT NULL,
`config_value` MEDIUMTEXT NOT NULL,
`config_type` MEDIUMTEXT NOT NULL,
PRIMARY KEY (`config_id`)
)";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type) VALUES ('avatars','','header')";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type) VALUES ('avatar_height','48','avatars')";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type) VALUES ('avatar_width','48','avatars')";
$sql[] = "ALTER TABLE `".$table_prefix."nulavatar_settings` ADD config_isradio TINYINT(1) NOT NULL DEFAULT '0' ";
$sql[] = "ALTER TABLE `".$table_prefix."nulavatar_settings` ADD config_radio_choices MEDIUMTEXT NOT NULL DEFAULT '' ";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('rpgmod','','header','','')";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('rpgsystem','moogies','rpgmod','1','moogies,shop3,adr')";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('imagetype','png','avatars','1','png,gif')";
$sql[] = "CREATE TABLE `".$table_prefix."nulavatar_images` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` mediumtext NOT NULL,
`image` mediumtext NOT NULL,
`layer` int(10) NOT NULL default '0',
`itemneeded` mediumtext NOT NULL,
`dontshowlayer` int(10) NOT NULL default '',
PRIMARY KEY (`id`)
)";
$sql[] = "CREATE TABLE `".$table_prefix."nulavatar_layers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` mediumtext NOT NULL,
`position` tinyint(3) NOT NULL default '0',
`compulsive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
)";
$sql[] = "CREATE TABLE `".$table_prefix."nulavatar_userchars` (
`id` int(10) unsigned NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '',
PRIMARY KEY (`id`)
)";
$dat[] = 'Creating table "nulavatar_settings"';
$dat[] = 'Updating Settings table';
$dat[] = 'Updating Settings table';
$dat[] = 'Updating Settings table';
$dat[] = 'Altering Settings table';
$dat[] = 'Altering Settings table';
$dat[] = 'Updating Settings table';
$dat[] = 'Updating Settings table';
$dat[] = 'Updating Settings table';
$dat[] = 'Creating "nulavatar_layers" table';
$dat[] = 'Creating "nulavatar_images" table';
$dat[] = 'Creating "nulavatar_userchars" table';
$dat[] = 'Updating Settings table';
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('generalconfig','','header','','')";
$dat[] = "Updating Settings table";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('display','1','generalconfig','1','0,1')";
$dat[] = "Updating Settings table";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('eamountofitems','5','generalconfig','0','')";
$dat[] = "Updating Settings table";
$sql[] = "INSERT INTO `".$table_prefix."nulavatar_settings` (config_name,config_value,config_type,config_isradio,config_radio_choi ces) VALUES ('replaceavatar','0','generalconfig','1','0,1,2')";
$sql_count = count($sql);
for($i = 0; $i < $sql_count; $i++) {
echo "" . $dat[$i];
flush();
if ( !$db->sql_query($sql[$i]) )
{
$errored = true;
$error = $db->sql_error();
echo "... <b><font color=\"FF0000\">FAILED</font></b><BR />Error Message:<i>" . $error['message'] . "</i><br />\n";
}
else
{
echo "... <b><font color=\"007700\">COMPLETED</font></b><br />\n";
}
}
echo "<br />\n<br />\n";
// Do CHMOD
$filename = $phpbb_root_path.'images/nulavatar_avatars/';
echo "Checking if NulAvatar is able to write to <b>".$filename."</b>... ";
if (file_exists($filename))
{
if (!is_writable($filename))
{
echo "<font color=\"orange\"><b>NO</b></font><br />\n Attempting to CHMOD <b>".$filename."</b> to 0777...";
if (!chmod($filename, 0777))
{
echo "<br />Could not CHMOD <b>".$filename."</b> to 0777! Please do it manually! (required for NulAvatar to save your avatars!)<br />\n";
}
else
{
echo "The folder <b>".$filename."</b> was succesfully CHMODded to 0777!<br />\n";
}
}
else
{
echo "<font color=\"007700\"><b>YES</b></font><br />\n";
}
}
else
{
echo "<font color=\"FF0000\"><b>NO</b></font><br />\n Make sure the folder exists!<br />\n";
}
echo "<br />\n<br />\n";
if( $errored ) {
$message = "The installation was <b>not</b> successful. Please try again!<br />If the problem persists, please post in the NulAvatar thread!";
}
else {
$message = "<b>NulAvatar has been installed succesfully!</b><br />Make sure to delete this install file!<br /><b>Enjoy!</b>";
}
echo "\n<br />\n<b>Finished!</b><br />\n";
echo $message . "<br />\n";
echo "</body>\n";
echo "</html>\n";
exit();
// End GD Check
}
?>
|
This is the nulavatar_install.php! |
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/14/2009 2:08 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:53 AM
Location: St Pete, FL
|
|
|
|
|
|
Just search for the field named dontshowlayer. That will take you to the line that needs to be corrected. Then once you have that modified, the user field that you would modify next would be 14 lines down from the dontshowlayer field...
|
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/14/2009 2:36 AM |
|
|
|
|
Sparrow |
Posts |
11 |
Word Cnt. |
2,995 |
BDay |
N/A |
Sign |
N/A |
|
|
|
|
|
Joined: Jan 10, 2009
Local time: 1:53 AM
|
|
|
|
|
|
It says cannot find"dontshowlayer". Why? |
|
|
|
|
Back to Top |
|
|
| Re: Please help! lol! | |
Posted: 01/14/2009 2:40 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:53 AM
Location: St Pete, FL
|
|
|
|
|
|
I don't know what you are using for a text editor, but it is there. You can find it on line 181...
|
|
|
|
|
Back to Top |
|
|
| Information | |
|