Problems with AcmlmBoard, again

Points of Required Attention™

Please chime in on a proposed restructuring of the ROM hacking sections.

04-29-24 09:49 AM

Guest: Register | Login

0 users currently in Computing | 1 guest

Main - Computing - Problems with AcmlmBoard, again

New thread | New reply

Pages: 1 2

pieguy1732

Posted on 05-18-08 01:36 AM

Link | Quote | ID: 83820

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1033/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

I'm using AcmlmBoard v1.92, but when I try to register, the account is not created.

Is there a solution?

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

blackhole89

Posted on 05-18-08 01:37 AM

Link | Quote | ID: 83822

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1649/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

Is there any error output?

Does your DB account have access to the relevant table to begin with, did you import the table structure etc.?

____________________

pieguy1732

Posted on 05-18-08 01:39 AM

Link | Quote | ID: 83823

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1035/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

Yes, I did all that.

Basically, what happens is that I register; however, after I'm done, my account isn't there, like I never registered. No errors or anything come up. :o

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

blackhole89

Posted on 05-18-08 01:41 AM

Link | Quote | ID: 83825

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1650/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

Some Acmlmboard developers had the habit to prefix MySQL calls with @s, suppressing error output... try removing any of those before mysql_ functions in register.php and trying again.

____________________

pieguy1732

Posted on 05-18-08 01:42 AM

Link | Quote | ID: 83827

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1036/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

There are no instances of "@s" in register.php.

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

Sukasa

Posted on 05-18-08 01:44 AM

Link | Quote | ID: 83828

Red Birdo
Level: 92

Posts: 758/2112
EXP: 7691175
Next: 65762

Since: 02-19-07

Last post: 4451 days
Last view: 3222 days

Try adding "echo mysql_Error();" after the mysql_query() functon calls, sometimes that happens to my code too; it'll seem to work, yet nothing goes through.

pieguy1732

Posted on 05-18-08 01:52 AM (rev. 2 of 05-18-08 01:52 AM)

Link | Quote | ID: 83831

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1037/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

Oh, look:

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 '0,",",50,1,1,1)' at line 1

Thanks for that; however, I can't find the source of the error. (I know it says line 1, but there's nothing of the sort on line 1 of any sort)

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

blackhole89

Posted on 05-18-08 01:54 AM

Link | Quote | ID: 83832

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1653/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

Can you link me to the source of your register.php?
(Making a copy and renaming it to .phps should do the trick on most server configurations.)

____________________

pieguy1732

Posted on 05-18-08 01:56 AM

Link | Quote | ID: 83833

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1038/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

.phps didn't work, so here is a .txt with the source:

http://pieguy1372.freeweb7.com/board/register.txt

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

blackhole89

Posted on 05-18-08 02:07 AM

Link | Quote | ID: 83834

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1654/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

Find

mysql_query("INSERT INTO users(id,posts,regdate,name,password,picture,signature,bio,powerlevel,title,lastactivity,email,icq,aim,sex,homepageurl,timezone,postsperpage,realname,location,lastip,lastposttime,postheader,useranks,birthday,scheme,minipic,homepagename,threadsperpage,posttool,viewsig,layout) VALUES(NULL,0,$currenttime,'".addslashes($username)."','".md5($password)."','".addslashes($picture)."','".addslashes($signature)."','".addslashes($bio)."',$userlevel,\"\",$currenttime,'".addslashes($email)."',$icq,'".addslashes($aim)."',$sex,'".addslashes($homepage)."',$timezone,$postsperpage,'".addslashes($realname)."','".addslashes($location)."','".addslashes($ipaddr)."',0,'".addslashes($postheader)."',1,$birthday,$sscheme,'".addslashes($minipic)."','".addslashes($pagename)."',$threadsperpage,$posttool,$viewsig,$tlayout)");

and replace with

mysql_query($temp="INSERT INTO users(id,posts,regdate,name,password,picture,signature,bio,powerlevel,title,lastactivity,email,icq,aim,sex,homepageurl,timezone,postsperpage,realname,location,lastip,lastposttime,postheader,useranks,birthday,scheme,minipic,homepagename,threadsperpage,posttool,viewsig,layout) VALUES(NULL,0,$currenttime,'".addslashes($username)."','".md5($password)."','".addslashes($picture)."','".addslashes($signature)."','".addslashes($bio)."',$userlevel,\"\",$currenttime,'".addslashes($email)."',$icq,'".addslashes($aim)."',$sex,'".addslashes($homepage)."',$timezone,$postsperpage,'".addslashes($realname)."','".addslashes($location)."','".addslashes($ipaddr)."',0,'".addslashes($postheader)."',1,$birthday,$sscheme,'".addslashes($minipic)."','".addslashes($pagename)."',$threadsperpage,$posttool,$viewsig,$tlayout)");
echo $temp;

; then copy the output here.

____________________

pieguy1732

Posted on 05-18-08 02:13 AM (rev. 3 of 05-18-08 02:17 AM)

Link | Quote | ID: 83835

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1039/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

INSERT INTO users(id,posts,regdate,name,password,picture,signature,bio,powerlevel,title,lastactivity,email,icq,aim,sex,homepageurl,timezone,postsperpage,realname,location,lastip,lastposttime,postheader,useranks,birthday,scheme,minipic,homepagename,threadsperpage,posttool,viewsig,layout) VALUES(NULL,0,1211069660,'pieguy1372','a289a079ee14adf7be9297dbdf9274a1','','','',3,"",1211069660,'',0,'',2,'',0,20,'','','70.190.233.190',0,'',1,,0,'','',50,1,1,1)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 '0,'','',50,1,1,1)' at line 1

Also, don't even try posting in this thread NightKev. >:

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

blackhole89

Posted on 05-18-08 02:16 AM

Link | Quote | ID: 83837

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1655/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

I remember now.
As it is, you need to provide a birthday when registering; otherwise, mktime returns an empty string. The easiest way I can think of to counter the resulting problems is replacing the aforementioned line with the following:

mysql_query("INSERT INTO users(id,posts,regdate,name,password,picture,signature,bio,powerlevel,title,lastactivity,email,icq,aim,sex,homepageurl,
timezone,postsperpage,realname,location,lastip,lastposttime,postheader,useranks,birthday,scheme,minipic,homepagename,threadsperpage,posttool,viewsig,layout) VALUES(NULL,0,$currenttime,'".addslashes($username)."','".md5($password)."','".addslashes($picture)."','".addslashes($signature)."','".addslashes($bio)."',
$userlevel,\"\",$currenttime,'".addslashes($email)."',$icq,'".addslashes($aim)."',$sex,'".addslashes($homepage)."',$timezone,$postsperpage,'".addslashes($realname)."',
'".addslashes($location)."','".addslashes($ipaddr)."',0,'".addslashes($postheader)."',1,'$birthday',$sscheme,'".addslashes($minipic)."','".addslashes($pagename)."',
$threadsperpage,$posttool,$viewsig,$tlayout)");

____________________

NightKev

Posted on 05-18-08 02:17 AM

Link | Quote | ID: 83838

Cape Luigi
Level: 131

Posts: 2733/4792
EXP: 26236227
Next: 188393

Since: 03-15-07

Last post: 3737 days
Last view: 3649 days

Quick question pieguy: what are you planning to do with it once you get it to work? Is it going to be an actual board or are you just playing around with it?

____________________

blackhole89

Posted on 05-18-08 02:19 AM (rev. 2 of 05-18-08 02:19 AM)

Link | Quote | ID: 83839

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1656/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

By the way, I should've noticed earlier: This belongs into H/S, not Programming.

Moving.

I'm growing old.

____________________

pieguy1732

Posted on 05-18-08 02:21 AM (rev. 3 of 05-18-08 05:49 AM)

Link | Quote | ID: 83840

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1040/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

Thanks, it works now.

~~I suppose I'll have to do the same to editprofile.php to get that to work as well, as I remember a board where that didn't work for that reason.~~

I have another problem. The posts don't show up when viewing a thread!

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

blackhole89

Posted on 05-18-08 06:00 AM

Link | Quote | ID: 83864

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1658/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

But you know for sure the posts are there?

It might help to check your posts-per-page settings and ensure the DB structure version actually matches the code version.

____________________

pieguy1732

Posted on 05-18-08 06:05 AM

Link | Quote | ID: 83865

Ptooie
Note: I wasn't here because I wasn't here, not because someone switched the 7 and the 3.
Level: 84

Posts: 1045/1711
EXP: 5463908
Next: 198044

Since: 01-04-08

Last post: 5020 days
Last view: 4949 days

I'm sure that they're there, because when replying to a thread they show up under the post textbox.

____________________
"There are 3 types of people in this world: Those who can count and those who can't."

OoBurns

Posted on 05-18-08 03:55 PM

Link | Quote | ID: 83882

Boo
Level: 68

Posts: 1019/1036
EXP: 2642190
Next: 86610

Since: 02-19-07
From: It is a mystery.

Last post: 5725 days
Last view: 5725 days

I know that, when I tried it a while back, 1.92 tended to do strange things when running on MySQL 5. I never did bother to find out why, though, so I'm afraid I won't be much help.

____________________

blackhole89

Posted on 05-18-08 04:09 PM

Link | Quote | ID: 83884

The Guardian
Moloch whose eyes are a thousand blind windows!
Level: 124

Posts: 1661/4196
EXP: 21538010
Next: 298591

Since: 02-19-07
From: Ithaca, NY, US

Last post: 474 days
Last view: 87 days

Ah, right, MySQL 5. There were some problems with LEFT JOINing order in queries with it where the behaviour changed; can you link to the source of affected files?

____________________

IIIMarckus

Posted on 05-18-08 06:30 PM

Link | Quote | ID: 83899

Rat
Level: 23

Posts: 28/89
EXP: 65692
Next: 2031

Since: 07-26-07
From: Liz Island

Last post: 4854 days
Last view: 4846 days

Not to interrupt, but what advantage does 1.92 have over 1.a3? Fewer bugs?

____________________
hax.iimarck.us

Pages: 1 2

Main - Computing - Problems with AcmlmBoard, again

New thread | New reply

Page rendered in 0.034 seconds. (323KB of memory used)
MySQL - queries: 87, rows: 115/116, time: 0.017 seconds.