HTMLHelp Forums > mysql error

HTMLHelp Forums > Programming > Databases

ofi

Dec 12 2008, 06:48 PM

Hi all

i am trying out news system called n13, i have installed it, it works fine, but when i try to include it, i get these errors.

CODE

Warning: mysql_query() [function.mysql-query]: Access denied for user 'almenntc'@'localhost' (using password: NO) in /home/almenntc/public_html/ny_sida/n13/index.php on line 13

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/almenntc/public_html/ny_sida/n13/index.php on line 13

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/almenntc/public_html/ny_sida/n13/index.php on line 14

Warning: mysql_query() [function.mysql-query]: Access denied for user 'almenntc'@'localhost' (using password: NO) in /home/almenntc/public_html/ny_sida/n13/index.php on line 187

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/almenntc/public_html/ny_sida/n13/index.php on line 187

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/almenntc/public_html/ny_sida/n13/index.php on line 188

Fatal error: Call to undefined function slash2() in /home/almenntc/public_html/ny_sida/n13/index.php on line 191

I am using this function

CODE

<?php
include 'n13/index.php';
?>

I have been trying to get support from support forum n13, without of luck, anyone hee can help with this.

Brian Chandler

Dec 12 2008, 10:42 PM

Well, the "code" you give just includes n13/index.php, so without seeing that file we can't say anything. The error messages suggest that you do not have a database set up in the way n13 requires.

Only "n13" can help you with this. Did you get documentation on how to install it? If there are bits you don't understand, you could ask about them here, but you will probably get help quicker if you can find someone else who is using it.

ofi

Dec 13 2008, 11:03 AM

Hi Brian
I have follow the install guide, and everything works fine there, and the admin panel is working fine to, i have included as it says.

and here is the n13.php

CODE

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-type" value="charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="almennt.css" />
<title>prufa</title>

</head>
<body>

<a name="top"></a>

<table border="0" width="770" cellpadding="0" cellspacing="0" align="center">
       <tr>

<td align="right" valign="top" width="5" height="100%" class="leftside">
<table border="0" class="lefttside" width="100%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="right" valign="top"><img src="images/misc/nav_ls.gif" alt="ls" /></td>
</tr>
<tr>
<td align="right" class="leftside" height="100%"><img src="images/misc/page_ls.gif" alt="ls" /></td>
</tr>
</table>

           </td>
           <td align="center" valign="top">
               <table border="0" width="100%" cellpadding="0" cellspacing="0" align="center">
                      <tr>
                          <td>

<table border="0" width="770" cellpadding="0" cellspacing="0" align="center">
<tr>
    <td align="left"><a href="index.php"><img src="images/misc/logo.gif" border="0" alt="Logo" /></a></td>
    <td align="right" valign="top">

        <a href="index.php"><img src="images/misc/icon_home.gif" border="0" alt="Home" /></a>
        <a href="sendmessage.php"><img src="images/misc/icon_contact.gif" border="0" alt="Contact" /></a>
        <a href="forum.php"><img src="images/misc/icon_sitemap.gif" border="0" alt="Site Map" /></a>
    </td>
</tr>
</table>
<table border="0" width="770" cellpadding="0" cellspacing="0" align="center" class="sitenav">
<tr>
    <td align="left">
        <table border="0" cellpadding="0" cellspacing="0" align="left">
               <tr>

                    <td><a href="index.php"><img src="images/misc/nav_heim.gif" border="0" alt="Heim" /></a></td>

           <td><a href="myndir.php"><img src="images/misc/nav_members.gif" border="0" alt="Myndir" /></a></td>
           <td><a href="spjall/"><img src="images/misc/nav_calendar.gif" border="0" alt="Spjall" /></a></td>
           <td><a href="eg.php"><img src="images/misc/nav_eg.gif" border="0" alt="Eg" /></a></td>

          <td><a href="samband.php"><img src="images/misc/nav_register.gif" border="0" alt="Samband" /></a></td>

              </tr>

           </table>
    </td>
</tr>
</table>

<table border="0" width="770" cellpadding="0" cellspacing="0" align="center" class="pagebg">
<tr>
    <td><img src="images/gradients/page_bg.gif" alt="bg" /></td>
</tr>
</table>

<div align="center">

    <div class="page" style="width:100%; text-align:left">
        <div style="padding:0px 25px 0px 25px" align="left">
</div>
<div style="padding:0px 25px 0px 25px" align="left">
<?php
$cat = "Category name";
include 'news/index.php';
?>
<br />

        </div>
    </div>
</div>

<table cellpadding="6" cellspacing="0" border="0" width="100%" class="page" align="center">
<tr>
<td class="tfoot" align="left" width="100%">
<div class="smallfont"><strong><a href="samband.php">Samband</a> - <a href="http://www.almennt.com/spjall">Spjall</a> - <a href="archive/index.php">Linkur</a> - <a href="#top" onclick="self.scrollTo(0, 0); return false;">Upp</a></strong></div>
</td>
</tr>
</table>

</td>
</tr>
</table>
</td>
<td align="left" valign="top" width="5" height="100%" class="rightside">
<table border="0" class="rightside" width="100%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="left" valign="top"><img src="images/misc/nav_rs.gif" alt="rs" /></td>
</tr>
<tr>
<td align="left" class="rightside" height="100%"><img src="images/misc/page_rs.gif" alt="rs" /></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

Brian Chandler

Dec 13 2008, 11:22 AM

Well, I don't know what n13.php is, but it appears to be just html. There are no function calls visible.

Look, here's the (first) error message:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'almenntc'@'localhost' (using password: NO) in /home/almenntc/public_html/ny_sida/n13/index.php on line 13

This tells you that on line 13 of the named file, there is a call to mysql_query(). If you look at that line of that file, you should see the call. There is something wrong with the call - iirc, this should have been preceded by a mysql_connect() call, to connect to the db server.

Perhaps you missed out an initialisation call to the n13 stuff? Perhaps they are using OOP stuff, with PHP5, and you are using PHP4?

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.