Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,954,308
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-29-24 12:03 PM
Guest: Register | Login

0 users currently in AcmlmBoard II Software/Bug Report Forum | 2 guests | 7 bots

Main - AcmlmBoard II Software/Bug Report Forum - status.php broken
Next newer thread | Next older thread


Kak
Posted on 06-23-14 10:55 AM, in (rev. 3 of 06-23-14 11:37 AM by Kak) Link | ID: 67757
Global Moderator

Bullet Bill
well then
Level: 129


Posts: 3988/5515
EXP: 24952203
Next: 97451

Since: 01-29-14
From: ???

Last post: 809 days
Last view: 755 days
Post #3988
I've tried to get the latest development version of Acmlmboard working on my (for now) localhost Apache server.

After ironing out errors with default values in many places (thanks, SQL), therefore fixing the problem with the users not being able to register, post text not being saved correctly to the database, and adding a gross hack, it seemed nothing would be broken. In fact, it isn't, except for a little detail.


status.php can't create the PNG image.

I made sure the default PHP-GD library (php_gd2.dll) is loaded, however I think the problem could be part of my current PHP/Apache configuration, since it also happens in the other (Acmlmboard 1.96) test board. I don't really know where the problem lies, since the only errors in the log files are about the undefined constants that appear in many other places. Link to the log file.

EDIT: It seems the exp bars are not showing up either

Any ideas?

-----

Arisotura
Posted on 06-23-14 08:53 PM, in Link | ID: 67952
Developer
pancakes
Level: 83


Posts: 551/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
One of the board's files (lib/config.php) has an UTF8 BOM that keeps coming back for whatever reason.

Said BOM is output at the beginning of images and breaks them. Retarded PHP.


Open that file in a good text editor and save it as UTF8 without BOM.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kak
Posted on 06-24-14 05:31 AM, in Link | ID: 68044
Global Moderator

Bullet Bill
well then
Level: 129


Posts: 4048/5515
EXP: 24952203
Next: 97451

Since: 01-29-14
From: ???

Last post: 809 days
Last view: 755 days
Posted by StapleButter
One of the board's files (lib/config.php) has an UTF8 BOM that keeps coming back for whatever reason.

Said BOM is output at the beginning of images and breaks them. Retarded PHP.


Open that file in a good text editor and save it as UTF8 without BOM.
Yes, there's a BOM so with Notepad++ (the only editor I ever used for editing the files since standard Notepad breaks the layout and can mess up some charaters) I could save it without BOM, but the image still can't be created. I dragged the file on the desktop and I opened it, and I saw this at the beginning of the "image":

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR id= OR id= OR id= OR id= OR id= OR id=0' at line 1‰"

That is most likely referring to:

$eqitems=$sql->query("SELECT * FROM items WHERE id=$user[eq1] OR id=$user[eq2] OR id=$user[eq3] OR id=$user[eq4] OR id=$user[eq5] OR id=$user[eq6] OR id=$it");

Arisotura
Posted on 06-24-14 06:56 PM, in Link | ID: 68093
Developer
pancakes
Level: 83


Posts: 557/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
Which Acmlmboard version/revision are you using? I hope this isn't some register_globals remnant because we removed them all.

My guess would be that there's some RPG data missing in the database (users_rpg table), but if that's the case you should also see warnings on your profile page.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Emuz
Posted on 06-24-14 10:41 PM, in Link | ID: 68101
Site Administrator

11 Hit Combo:
Mother's Rosario
Level: 108


Posts: 2315/3392
EXP: 13211957
Next: 308542

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 116 days
Last view: 1 day
I've never used it on Windows so I wouldn't know if there would be an effect. the gfx libs are the most easily broken of all the code due to your installation.

The common issues are how the paths to the included files are being read in. Since it's all in gfx/ that has caused problems as the well.

There should be code to throw an error if reg_globals is on. So that shouldn't be it. I wonder if it's something server related only due to the fact AB1 acts identically.

The Dynamic Profile Administratorâ„¢


"Never Knows Best"
Note: if you can see this my layout broke. ALL THE CREDITS WILL BE REVEALED!!
'Victory Noriko' by @thatsheepagain.
'Chibi Dance Noriko' by @Haru__Kitsu.
'Deity's Night Out (Featuring Gabbie)'
by @thatsheepagain
Noriko Emotes by @Haru__Kitsu.
Side Bar Noriko by @thatsheepagain
'Noriko's Nature Walk' by @projectTiGER_
Emotive Noriko by @thatsheepagain.
"Space Candy Noriko" by BerryVerrine.
"Super Sharp Noriko" by Xionfes.
A gift illustration from the wonderful EverKinzPony!
"Magical Girl Noriko" by @cute_hospital!
"Patient Chibi Noriko" by @Ruii_ki!
'Dapper '60s Noriko' by @thatsheepagain.
'Shiny Chibi Noriko' by @inioli.
'Flower Veil Noriko' by @Sushiee_.
'Noriko in Realism' by @_Sarybuu.
'Noriko's Midnight Adventure' by @projectTiGER_
'Yukata Noriko' by @yunyunmaru_
'Birthday Wishes Noriko' by @thatsheepagain

Arisotura
Posted on 06-24-14 10:52 PM, in Link | ID: 68105
Developer
pancakes
Level: 83


Posts: 558/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
Nah, I meant, if he's using old code that hasn't been fixed to not rely on register_globals. Like, it'd use $id instead of $_GET['id'].

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kak
Posted on 06-24-14 11:05 PM, in Link | ID: 68108
Global Moderator

Bullet Bill
well then
Level: 129


Posts: 4052/5515
EXP: 24952203
Next: 97451

Since: 01-29-14
From: ???

Last post: 809 days
Last view: 755 days
Posted by StapleButter
Which Acmlmboard version/revision are you using?
My guess would be that there's some RPG data missing in the database (users_rpg table), but if that's the case you should also see warnings on your profile page.
I'm currently using the latest revision (I updated it some hours ago), and there are no warning in the profile page - the only warning I do get is this "descriptive" SQL warning on the item shop when selecting a category (ie. there's no error when the PHP file is called without extra arguments).

Posted by Emuz
The common issues are how the paths to the included files are being read in. Since it's all in gfx/ that has caused problems as the well.

There should be code to throw an error if reg_globals is on. So that shouldn't be it. I wonder if it's something server related only due to the fact AB1 acts identically.
The error report showed only notices in the php_errors.log, so I doubt that there are problems with calling the included files (it should have given a warning, had that happened (I think)).

Arisotura
Posted on 06-24-14 11:11 PM, in Link | ID: 68109
Developer
pancakes
Level: 83


Posts: 559/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
Well uh, try opening lib/mysql.php and making it display/log SQL queries that fail, along with the MySQL error.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kak
Posted on 06-25-14 07:13 AM, in Link | ID: 68126
Global Moderator

Bullet Bill
well then
Level: 129


Posts: 4053/5515
EXP: 24952203
Next: 97451

Since: 01-29-14
From: ???

Last post: 809 days
Last view: 755 days
Posted by StapleButter
Well uh, try opening lib/mysql.php and making it display/log SQL queries that fail, along with the MySQL error.


I did so, and this is what I got:
SELECT u.name, u.posts, u.regdate, r.* FROM users u LEFT JOIN usersrpg r ON u.id=r.id WHERE u.id=1
SELECT eq1 AS e FROM usersrpg WHERE id=1
SELECT * FROM items WHERE id=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


The line where id "doesn't point to any value" is this:
$eqitems=$sql->query ('SELECT * FROM items');


It always seems to add "WHERE id=" in the query fro some reason.

Arisotura
Posted on 06-25-14 11:25 AM, in Link | ID: 68131
Developer
pancakes
Level: 83


Posts: 560/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
You weren't looking at the right query.

$eqitem=$sql->fetchq("SELECT * FROM items WHERE id=$eq[e]");

$eq[e] is NULL. Probably due to the lack of items or categories in the shop.

Shop should fail more gracefully upon that...

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kak
Posted on 06-25-14 01:39 PM, in (rev. 3 of 06-25-14 01:44 PM by Kak) Link | ID: 68132
Global Moderator

Bullet Bill
well then
Level: 129


Posts: 4054/5515
EXP: 24952203
Next: 97451

Since: 01-29-14
From: ???

Last post: 809 days
Last view: 755 days
Post #4054
Wait, I realized the problem now.

The id in the shop was set to 5, while my current user id is 1. It may be due to deleting user IDs at some point.

Now the shop doesn't have show any more SQL errors, but still there's still the problem of status.php not generating the PNG. :|

EDIT: It works now. This means the wrong user ID was causing problems.



I realized then the reason why the AB1.x test board didn't show the status: I had to create the user manually since the Registration page was broken. I didn't create a valid shop user id so the shop was broken there too.

-----

Arisotura
Posted on 06-25-14 01:40 PM, in Link | ID: 68134
Developer
pancakes
Level: 83


Posts: 561/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
Any SQL errors in the PNG?

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-25-14 01:49 PM, in Link | ID: 68140
Developer
pancakes
Level: 83


Posts: 562/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
The available AB1.x builds don't have the item shop implemented. Only 1.B0+ and 1.92.08 have it, and those don't seem to be available anywhere.

(1.92.08 isn't to be confused with 1.92; 1.92.08 happened after Xkeeper reverted Acmlm's Board from 1.B0+ to 1.92)

As for AB1.x's registration page, the code checking for birthdays was written for PHP4 and never adapted to PHP5. You need to enter a valid birthdate or it will fail silently.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kak
Posted on 06-25-14 02:20 PM, in Link | ID: 68152
Global Moderator

Bullet Bill
well then
Level: 129


Posts: 4058/5515
EXP: 24952203
Next: 97451

Since: 01-29-14
From: ???

Last post: 809 days
Last view: 755 days
That test board is well, this.

There's no reason I have it on my server - I "installed" it in all its broken glory just to experiment with.

Arisotura
Posted on 06-27-14 12:37 PM, in Link | ID: 68318
Developer
pancakes
Level: 83


Posts: 567/1868
EXP: 5395906
Next: 36315

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
Oh, the Jul Acmlmboard.

It'd be more interesting to have the last version, with all of Inuyasha's fixes and improvements. But well. Not like it matters.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Next newer thread | Next older thread
Main - AcmlmBoard II Software/Bug Report Forum - status.php broken


Acmlmboard v2.5.5 (10/04/2020)
© 2005-2024 Acmlm, Emuz, et al.

Page rendered in 0.080 seconds. (873KB of memory used)
MySQL - queries: 179, rows: 594/626, time: 0.054 seconds.