(Link to AcmlmWiki) Offline: thank ||bass
Register | Login
Views: 13,040,846
Main | Memberlist | Active users | Calendar | Chat | Online users
Ranks | FAQ | ACS | Stats | Color Chart | Search | Photo album
05-18-24 04:21 PM
0 users currently in Programming.
Acmlm's Board - I3 Archive - Programming - forum.php woes! New poll | |
Add to favorites | Next newer thread | Next older thread
User Post
cpubasic13
I'm ahead of myself...
Wait...









Since: 11-17-05
From: Citra, Fl.

Last post: 6300 days
Last view: 6298 days
Skype
Posted on 01-14-06 12:08 AM Link | Quote
Umm... so I have decided to try and make an Acmlmboard based off of 1.92. I got it all set up and made the first catergory and forum. However, when I click the forum, I get this error message.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/cpubasic1337/forum.php on line 58
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/export/www/hosting/cpubasic1337/forum.php on line 66

Looking into it, lines 58-60 and 66-68 are:
if($annc=mysql_fetch_array($anncs)){
$namecolor=getnamecolor($annc[sex],$annc[powerlevel]);
print "

Now I know what that might mean (get the namecolor from the sex and powerlevel settings) but what is strange is that I made no changes to forum.php at all.

Got any idea how to fix and an explanation why? (If I am going to learn PHP, best be from mistakes, right?)
Randy53215

Melon Bug


 





Since: 11-17-05
From: Greenfield, Wisconsin (U.S.A)

Last post: 6299 days
Last view: 6298 days
Skype
Posted on 01-14-06 02:04 AM Link | Quote
Any errors anywhere else?
Ice Man

Panser



 





Since: 11-18-05
From: Germany

Last post: 6398 days
Last view: 6334 days
Posted on 01-14-06 01:58 PM Link | Quote
Did you change something with the query above it? Or is something wrong with the announcements code?
Randy53215

Melon Bug


 





Since: 11-17-05
From: Greenfield, Wisconsin (U.S.A)

Last post: 6299 days
Last view: 6298 days
Skype
Posted on 01-15-06 03:49 AM Link | Quote
Originally posted by cpubasic13
but what is strange is that I made no changes to forum.php at all.
Ice Man

Panser



 





Since: 11-18-05
From: Germany

Last post: 6398 days
Last view: 6334 days
Posted on 01-15-06 05:45 AM Link | Quote
I know, Randy, just wanted to be sure. Anyway, try uploading a fresh copy of forum.php.
drizzt do'urden

Red Paragoomba


 





Since: 12-08-05
From: Oregon

Last post: 6697 days
Last view: 6697 days
Posted on 01-15-06 02:06 PM Link | Quote
Well, when I went to his board and went to general, I get this one

Parse error: parse error, unexpected '}' in /usr/export/www/hosting/cpubasic1337/forum.php on line 59

So yea, probobly have to re upload a new Forum.php
cpubasic13
I'm ahead of myself...
Wait...









Since: 11-17-05
From: Citra, Fl.

Last post: 6300 days
Last view: 6298 days
Skype
Posted on 01-15-06 11:42 PM Link | Quote
Reuploaded. Same error.

I changed nothing other than what I was supposed to edit, which was config.php for access to MySQL and such.

I am obviously using Funpic for hosting, but seeing as how others were able to make 1.92 boards on it successfully, I don't see why my board is not working right.

Link: http://cpubasic1337.cp.totalandcompletefailure.net/

EDIT: Apparently, there is an error with announcement.php.
Line 24.
while($annc=mysql_fetch_array($anncs)){

...this is the problem, I believe. The forums work fine, but now this... I reuploaded it and it didn't work...
Hmmm... and yet I made no changes to this...


(edited by cpubasic13 on 01-15-06 11:08 PM)
Randy53215

Melon Bug


 





Since: 11-17-05
From: Greenfield, Wisconsin (U.S.A)

Last post: 6299 days
Last view: 6298 days
Skype
Posted on 01-16-06 12:40 AM Link | Quote
Is there a closing bracket like so....

}?
cpubasic13
I'm ahead of myself...
Wait...









Since: 11-17-05
From: Citra, Fl.

Last post: 6300 days
Last view: 6298 days
Skype
Posted on 01-16-06 01:24 AM Link | Quote
Apparently, there is.

I would paste the code here, but it messes up... eh... but it does have a closing bracket.


(edited by cpubasic13 on 01-16-06 12:26 AM)
VGFreak877

Kabu


 





Since: 11-17-05

Last post: 6319 days
Last view: 6300 days
Skype
Posted on 01-16-06 02:36 AM Link | Quote
Okay, the brackets have nothing to do with the error at hand here. I may know what the problem is. Check to make sure that the variable $anncs is calling for fields that are actually in the announcements table in PMA. Those errors came up for a reason, as it would likely be one of these three possibilities: (1) The setup was done wrong. (2) The announcements table is misspelled. (3) Or one of the fields that is being called in that query line is missing.


(edited by VGFreak877 on 01-16-06 01:37 AM)
cpubasic13
I'm ahead of myself...
Wait...









Since: 11-17-05
From: Citra, Fl.

Last post: 6300 days
Last view: 6298 days
Skype
Posted on 01-22-06 09:58 PM Link | Quote
It was problem 1, VGFreak. Somehow it didn't create the table for announcements when I ran install.sql. Well, now it works.

Thanks for your help, though. Really appreciate it.
Add to favorites | Next newer thread | Next older thread
Acmlm's Board - I3 Archive - Programming - forum.php woes! |


ABII

Acmlmboard 1.92.999, 9/17/2006
©2000-2006 Acmlm, Emuz, Blades, Xkeeper

Page rendered in 0.009 seconds; used 399.68 kB (max 491.52 kB)