Jump to content


Photo

Asnforum


  • Please log in to reply
6 replies to this topic

#1 baterdene

baterdene
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 03 February 2006 - 07:36 PM

Hi,
I have tried to follow the instruction below, but could not get the web forum working. Could anybody tell me what should be done if one to follow this instruction? What is a "MySQL table based on "asnforum.sql" ASCII file" (where asnforum is the forum name)?

Create MySQL table based on "asnforum.sql" ASCII file. Use MySQL management software such as "PhpMyAdmin" to make this job easy.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 February 2006 - 08:48 PM

Huh? Sounds like they want you to run the SQL statements found in that file.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 baterdene

baterdene
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 03 February 2006 - 09:55 PM

Thanks for replying! MySQL Server 5.0 is running on my computer. I can open this forum's index page. But if I try to access the admin page, I get the message below:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\Apache\htdocs\forum\admin.php on line 32
No records found!

If I try to post a new topic, I get the following message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\Apache\htdocs\forum\newtopic.php on line 83

Try the last action for yourself using the link below:

[a href=\"http://www.emcd.info/forum/index.php\" target=\"_blank\"]webpage[/a]

#4 baterdene

baterdene
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 03 February 2006 - 11:35 PM

I think I have solved the problem myself. However, I have a new problem. When I submit a new topic, I get the message "No posting found" instead of the topic being posted. Try for yourself what I am talking about using the link below:

[a href=\"http://www.emcd.info/forum/index.php\" target=\"_blank\"]webpage[/a]


Do you think there is an error in the following script and that is why I am getting this result:

<?php

/*
___________________________________________________

project : asn forum version 2.0
file : newtopic.php
author : asn - webmaster@tourdebali.com
date : november 25th, 2004
note : copyright 2004 by asn
___________________________________________________

*/


include("config.php");
include("lib.php");
include("header.php");

?>

<script LANGUAGE="JavaScript">
function textCounter(field, countfield, maxlimit) {
if (field.value.length > maxlimit) // if too long...trim it!
field.value = field.value.substring(0, maxlimit);
// otherwise, update 'characters left' counter
else
countfield.value = maxlimit - field.value.length;
}
</script>

<table width="200" border="0" cellspacing="0" cellpadding="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="#f5f5f5">
<tr>
<td class="normal" align="center"><b>&nbsp;&nbsp;&nbsp;<a href="index.php" class="none">Forum Home</a>&nbsp;&nbsp;&nbsp;</b></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<b><span class="normal">Write your topic and welcome to Asn Forum!</span></b><br><br>
<form method="post" action="addtopic.php" name="posting">
<table width="500" border="0" cellspacing="0" cellpadding="15" class="replyform" bgcolor="#FBFBF0">
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr>

<td width="25%" class="normal"><b>Your Name<font color="#FF0000">*</font></b></td>
<td width="75%">
<input type="text" name="nama">
</td>
</tr>
<tr>
<td class="normal"><b>Email<font color="#FF0000">*</font></b></td>
<td width="72%">
<input type="text" name="email" size="30">
</td>
</tr>
<tr>
<td class="normal"><b>Homepage</b></td>
<td>
<input type="text" name="homepage" size="30" value="http://">
</td>
</tr>
<tr>
<td class="normal"><b>Subject<font color="#FF0000">*</font></b></td>
<td>
<input type="text" name="topic" size="40">
</td>
</tr>
<tr>
<td class="normal" valign="top"><br><br><br><b>Topic Text<font color="#FF0000">*</font></b></td>
<td class="normal">
<textarea name="topictext" rows="7" cols="35" onKeyDown="textCounter(this.form.topictext,this.form.remLen,<?php echo $maxchar; ?>);" onKeyUp="textCounter(this.form.topictext,this.form.remLen,<?php echo $maxchar; ?>);"></textarea><br>
Character Left: <input readonly type=text name=remLen size=3 maxlength=3 value="<?php echo $maxchar; ?>">
<table border="0" cellspacing="0" cellpadding="5">

<?php
$query_smile = mysql_query("SELECT MIN(id), code, smile_url, emotion FROM forum_smile GROUP BY emotion LIMIT 0,20");
$counter = 10;
while($data_smile = mysql_fetch_row($query_smile)) {
if (($counter % 10) == 0) echo "<tr>";
echo "<td><a href=\"javascript:void(0);\" onClick=\"document.posting.topictext.value+='$data_smile[1] ';\"><img src=\"images/$data_smile[2]\" border=\"0\" alt=\"$data_smile[3]\"></a></td>";
if (($counter % 10) == 9) echo "</tr>";
$counter++;

}
?>
</table>
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<input type="submit" name="Submit" value="Submit">
</td>
</tr>
</table></tr></table></form>

<?php include("footer.php"); ?>

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 04 February 2006 - 02:49 AM

That script doesn't do anything -- it would be that form's action that would be responsible for actually inserting a new topic. But posting the entire script is not the best way to debug this -- see what actually happens on the DB end.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#6 baterdene

baterdene
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 04 February 2006 - 12:37 PM

I have only started learning MySQL so I guess I would not find what is wrong. If you do not mind, could you try installing this forum on your system. I have provided the source below:

[a href=\"http://script.tourdebali.com/asnforum.html\" target=\"_blank\"]source web page[/a]

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 04 February 2006 - 07:38 PM

Install the forum? Not a chance -- this is a help forum, not a tech support forum, and no one has time for that; besides, the author has posted his e-mail address ([a href=\"mailto:mailto:webmaster@tourdebali.com\"]mailto:webmaster@tourdebali.com[/a]) for bugs & errors.

Like I said before, the error that you describe is being produced by the page that the form is being posted to (see the action attribute of the form tag). Take a look at that script, and begin debugging there. Initially, this will be in PHP, so your inexperience with MySQL should not make much of a difference. Besides, it's a great way to improve your skills.

Good luck.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users