Help - Search - Members - Calendar
Full Version: Sql Problems.. Help Pls..
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
nin_sensei
Pls.. guys help me.. i'm totally newbie with SQL.. honestly i just bought a PTC script so i just uploaded everything.. but whenever i'm visiting the site, i'm having this problem.. you could also visit my site to check whats wrong http://myclix.99k.org/

QUOTE
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 388

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 388

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 389


and also this..

Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348


QUOTE
Paid out:
$
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 17

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 17
Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO)
aXXo
QUOTE(nin_sensei @ Mar 13 2008, 10:57 PM) *
Pls.. guys help me.. i'm totally newbie with SQL.. honestly i just bought a PTC script so i just uploaded everything.. but whenever i'm visiting the site, i'm having this problem.. you could also visit my site to check whats wrong http://myclix.99k.org/
and also this..

Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348


please post a little bit of your code in that particular line so we can find the solution. maybe it just an error of your code.
nin_sensei
QUOTE(aXXo @ Mar 14 2008, 01:07 AM) *
please post a little bit of your code in that particular line so we can find the solution. maybe it just an error of your code.


sorry i'm totally beginner with this.. i just uploaded the whole PHP script.. so i don't know how could i provide you the code.. if you could instruct me how.. i'm willing to post it..
aXXo
use any of html or php editor and look for the line that had error in it. i use micromedia dreamweaver to edit my file so theres no big deal. it is fairly easy to create html file & convert it to php (with simple php coding though).

eg :

Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

as you can see here, the file that has error in it is "function.php" so just open the editor or text editor (if you don't have any of mention editor above) that have line numbering function. just look for the line number.
nin_sensei
QUOTE(aXXo @ Mar 14 2008, 02:43 AM) *
use any of html or php editor and look for the line that had error in it. i use micromedia dreamweaver to edit my file so theres no big deal. it is fairly easy to create html file & convert it to php (with simple php coding though).

eg :

Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

as you can see here, the file that has error in it is "function.php" so just open the editor or text editor (if you don't have any of mention editor above) that have line numbering function. just look for the line number.


ok i'm trying to do that now.. by the way.. i've got a mysql.sql file in the script folder.. i'm just wondering if i need to upload it on file server or as an import php managment?

the first contents of the mysql.sql file is this

QUOTE
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 30, 2005 at 06:56 PM
-- Server version: 4.0.0
-- PHP Version: 4.2.3
--
-- Database: `power_cashe`
--

-- --------------------------------------------------------

--
--


do i need to edit the database: 'power_cashe' to my database name? or replace the "host: localhost"?
nin_sensei
QUOTE(aXXo @ Mar 14 2008, 02:43 AM) *
use any of html or php editor and look for the line that had error in it. i use micromedia dreamweaver to edit my file so theres no big deal. it is fairly easy to create html file & convert it to php (with simple php coding though).

eg :

Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'75.126.138.75' (using password: NO) in /www/99k.org/m/y/c/myclix/htdocs/scripts/functions.php on line 348

as you can see here, the file that has error in it is "function.php" so just open the editor or text editor (if you don't have any of mention editor above) that have line numbering function. just look for the line number.


i've downloaded a free PHP editor and copy all the line with problems.. this is the result...

QUOTE
line 348
$ats = mysql_query("SELECT count(*) AS cnt FROM aff_ausers"); $row = mysql_fetch_array($ats);

line 388
$query = mysql_query("SELECT ID FROM adv_ban WHERE status='active'");

line 389
while ($skaiciuojami = mysql_fetch_array($query)) {$visoban++; $busrand[$visoban]=$skaiciuojami['ID'];}

line 17
$query = mysql_query($query) or die (mysql_error());;


that's it.. i hope you could solve my problem.. really need this site to works.. advance thanks..
Brandon
Hey where are you hosting your stuff to ? and if your hosting on Zymic then the SQL host is Localhost
nin_sensei
QUOTE(Crown @ Mar 14 2008, 03:34 PM) *
Hey where are you hosting your stuff to ? and if your hosting on Zymic then the SQL host is Localhost


i'm hosting on zymic.. may you help me pls crown? above this reply is the lines of the function.php that has an error.. and i don't understand the errors.. pls interpret it for me.. i'm really newbie with php..
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.