Message Board Logo [Home] [Search] [FAQ]
Message Board > Installation Help > MySQL says 1146...
[Private Message] [Register] [Profile] [Member list] [Log-in]
Who's Online:
There are 0 member(s), and 1 guest(s) online.
Members:  
Printable Version
[Post Reply]
Author Message
Elvellon
Junior Member
Posts : 2
Location : Sydney, Australia
Status    : Offline

MySQL says 1146...

Hey!

Right after I've installed the mysql_install.php and log on with test / test, I get the error
Parse error: syntax error, unexpected ';' in /customers/linaandalex.com/linaandalex.com/httpd.www/a_photogallery/admin/admin.php on line 185. How do I fix this?

----------------------
Mon 21 Apr 2008 @ 11:13 View Elvellon   Email Elvellon   Elvellon Home Page   Edit this messageQuote this message
Colin Birch
Admin
Posts : 28
Location : Pontypridd, S.Wales, UK
Status    : Offline

Hi
First you need to load admin.php into a text editor such as windows edit.
Go to line 185 which should be:-

echo;

Delete the line and resave the file. It must be saved in plain text format.
Re-upload the file to your web space and it should run without problem.

----------------------
FunkBoard
www.funkboard.co.uk
Mon 21 Apr 2008 @ 19:15 View Colin Birch   Email Colin Birch   Colin Birch Home Page   Edit this messageQuote this message
Elvellon
Junior Member
Posts : 2
Location : Sydney, Australia
Status    : Offline

Hi!

This is tha admin.php. I've tried what you said, but then I get "... on line 184" or 183 or something like that... could you please see if you can find anything wrong in the script? Thanks alot!




<?php

/*
This script is part of FunkGallery - a PHP-based Photo Gallery.
Copyright (C) 2004 Colin Birch

This copyright message MUST NOT be removed

You can contact Colin Birch at: colin@funkboard.co.uk
*/

require("global.php");
//10-03-04
// added $_cookie
// changed to _post & _get
// 16-12-05
// Added verify link

$action=$_POST['action'];
if(!$action) {$action=$_GET['action'];}
$fbadmin=$_COOKIE['fbadmin'];


$pass=$funk->db_query("SELECT templ_value FROM $templates WHERE templ_name='password'");

$pass=crypt($pass,'.N');

if($fbadmin==$pass) {

$ext="php";

if(!$action) {

echo "
<html>
<head>
<title>FunkGallery Control Panel</title>
<frameset rows="40,*">
<frame src="admin.$ext?action=head" name="head" scrolling="NO">
<frameset cols="170,*">
<frame src="admin.$ext?action=leftframe" name="nav" scrolling="AUTO">
<frame src="admin.$ext?action=mainframe" name="main" scrolling="AUTO">
</frameset>
</frameset>
</head>
</html>
";
} else {

if($action == 'head') {

echo "
<html>
<head>
</head>
<body>
<p><b><a href="../index.$ext" target="_top">View your Gallery</a></b></p>
</body>
</html>
<body>
";

} elseif($action == 'leftframe') {
?>

<html>
<head>
</head>
<body>

<p><b>Catagories</b><br>
<a target="main" href="cats.php">Configure</a></p>

<p><b>Galleries</b><br>
<a target="main" href="gallery.php">Configure</a></p>

<p><b>Photos</b><br>
<a target="main" href="addphotos.php">Add Photos</a><br>
<a target="main" href="adopt.php">Adopt Photos</a><br>
<a target="main" href="adopt2.php">Adopt Folders</a><br>
<a target="main" href="killphotos.php">Modify/Delete Photos</a>
<a target="main" href="verify.php">Verify Uploaded Photos</a></p>

<p><b>Main Comment</b><br>
<a target="main" href="comment.php">Edit/Delete Main Comment</a></p>

<p><b>Settings</b><br>
<a target="main" href="style.<?php echo "$ext"; ?>?action=editst">Edit Styles</a><br>
<a target="main" href="style.<?php echo "$ext"; ?>?action=dosett">Global Settings</a><br>
<a target="main" href="language.<?php echo "$ext"; ?>?action=choose">Bad Language</a></p>

<p><b>Info</b><br>
<a target="main" href="info.<?php echo "$ext"; ?>">General Info</a><br>
<a target="main" href="generalinfo.<?php echo "$ext"; ?>?action=notepad">Notepad</a><br>
<a target="main" href="generalinfo.<?php echo "$ext"; ?>?action=browsers">Browser Types</a><br>
<a target="main" href="generalinfo.<?php echo "$ext"; ?>?action=os">Operating system s</a><br>
<a target="main" href="generalinfo.<?php echo "$ext"; ?>?action=ref">Referers</a><br>
<a target="main" href="generalinfo.<?php echo "$ext"; ?>?action=robots">Robots</a>
</p>

<p><b>General</b><br>
<a target="main" href="admin.<?php echo "$ext"; ?>?action=mainframe">Main Screen</a></p>
</p>

<p><b>Log Out</b><br>
<a href="admin.<?php echo "$ext"; ?>?action=logout" target="_top">Log Out</a></p>
</body>
</html>

<?php
}
elseif($action == 'mainframe') {

?>

<html>
<head>
<title>FunkGallery Control Panel</title>
</head>
<body>
<p align="right"><b>Welcome to the FunkGallery Control Panel</b></p>

<?
$version=templates(version);
$build=templates(build);

?>

<p><b>Check for new versions</b><br>
<a href="http://www.funkgallery.co.uk/update.php?version=<? echo $version; ?>&build=<? echo $build; ?>">Update Check</a>
</p>


<p><b>Links</b><br>
<a href="http://www.funkgallery.com/" target="_blank">FunkGallery Home Page</a><br>
<a href="http://www.funkboard.co.uk/forum/" target="_blank">FunkGallery Support Forums</a><br>
</p>
<p>
<a href="http://www.php.net/" target="_blank">PHP Home Page</a><br>
<a href="http://www.mysql.com/" target="_blank">MySQL Home Page</a><br>
</p>

<p><b>FunkGallery Developer:</b><br>
<a href="mailto:colin@funkboard.co.uk">Colin Birch</a>: <I>Creator & Developer of FunkGallery.</i></p>

<p><b>If you find FunkGallery usefull please vote for it at one or both of these sites:-</b><br>
<a href="http://www.hotscripts.com/Detailed/30877.html" target="_blank">HotScripts</a><br>
<a href="http://www.php.resourceindex.com/detail/03584.html" target="_blank">PHP ResourceIndex</a><br>
</p>


<p>
While FunkGallery is and always will be free if you find it useful please feel free to make a small donation to help me fund further development<br>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but04.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
<input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIG9QYJKoZIhvcNAQcEoIIG5jCCBuICAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYCYgsYwv7qDKATYiWQzpM4SVMy2lGj8ycB2BzcYthMz3pjYl0HtQa5ITTL81UJbWVsIv6wKh7iJfPFflEbY3HNSH0qPDE1pf+FsHCXuy49jzabPeUY1JlM/aArCKfGjBkdasurV/BMARdh2NAHdglmMiAoqVfWGpjklBP9chsvx3TELMAkGBSsOAwIaBQAwcwYJKoZIhvcNAQcBMBQGCCqGSIb3DQMHBAiwU/+unPQuMYBQN0TmyZk2bdcmrG6AhTfJEG9ojGYDjOGgSY7tHtijfghg3wVp8X8LZeMQheFs03zSUf3RU7pKCSDfxrPJbiftO8Y5/tBXsm4EiTDhVuW5t2ygggOHMIIDgzCCAuygAwIBAgIBADANBgkqhkiG9w0BAQUFADCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20wHhcNMDQwMjEzMTAxMzE1WhcNMzUwMjEzMTAxMzE1WjCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMFHTt38RMxLXJyO2SmS+Ndl72T7oKJ4u4uw+6awntALWh03PewmIJuzbALScsTS4sZoS1fKciBGoh11gIfHzylvkdNe/hJl66/RGqrj5rFb08sAABNTzDTiqqNpJeBsYs/c2aiGozptX2RlnBktH+SUNpAajW724Nv2Wvhif6sFAgMBAAGjge4wgeswHQYDVR0OBBYEFJaffLvGbxe9WT9S1wob7BDWZJRrMIG7BgNVHSMEgbMwgbCAFJaffLvGbxe9WT9S1wob7BDWZJRroYGUpIGRMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbYIBADAMBgNVHRMEBTADAQH/MA0GCSqGSIb3DQEBBQUAA4GBAIFfOlaagFrl71+jq6OKidbWFSE+Q4FqROvdgIONth+8kSK//Y/4ihuE4Ymvzn5ceE3S/iBSQQMjyvb+s2TWbQYDwcp129OPIbD9epdr4tJOUNiSojw7BHwYRiPh58S1xGlFgHFXwrEBb3dgNbMUa+u4qectsMAXpVHnD9wIyfmHMYIBmjCCAZYCAQEwgZQwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tAgEAMAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNTAzMDQxOTA5MjBaMCMGCSqGSIb3DQEJBDEWBBQeZOexlXuZCk/9jmte4003AGE9fzANBgkqhkiG9w0BAQEFAASBgLwChfQGCUYoN2xqoTn4UdSZ7Gq3UUz1ywv/xmi8/GJIrNmyiU/DNdzg7mw/QA0T6E53d/iaQNCMigcaDHl+EtCRzwljVRugtUB5RmpMdMMJSw5qdT3Dy/O0OPk21rHt4BRed3Yn7bB43XA9mi733WSdO7kPpC8lP3ESAYYLZQX9-----END PKCS7-----
">
</form>
</p>


</body>
</html>

<?php

} elseif($action=='logout') {
setcookie("fbadmin", "");

echo "
<head>
<meta http-equiv="refresh" content="1; url=index.php">
</head>
You are now logged out. You are being forwarded back to the login page.
";

}
}

} else {

echo "<b>FunkGallery Admin</b><br><br>";
echo "Either your cookie has expired or you have not logged into your control panel<br>";
echo;

die("<a href="index.php">Click here</a> to log-in");
}
?>
Tue 22 Apr 2008 @ 05:46 View Elvellon   Email Elvellon   Elvellon Home Page   Edit this messageQuote this message
Colin Birch
Admin
Posts : 28
Location : Pontypridd, S.Wales, UK
Status    : Offline

The bit you need to edit it almost at the end. Look for

echo "<b>FunkGallery Admin</b><br><br>";
echo "Either your cookie has expired or you have not logged into your control panel<br>";
echo;

and alter it to

echo "<b>FunkGallery Admin</b><br><br>";
echo "Either your cookie has expired or you have not logged into your control panel<br>";

Just remove the

echo;

and re-save the file. It MUST be save in plain text format.

----------------------
FunkBoard
www.funkboard.co.uk
Tue 22 Apr 2008 @ 17:09 View Colin Birch   Email Colin Birch   Colin Birch Home Page   Edit this messageQuote this message
  Time in GMT
[Post Reply]
New posts since your last visit
Old post

Forum Jump:

My Homepage ][ Contact Us

Powered by FunkBoard vCF0.72