Trying to submit a forum...need help

[Chris_Seahorn]

I need someone with a PHP4 server and MySQL 4 databse server to test a forum submission. Wilbert has been trying but he's on a SQL5/PHP5 platform and the code won't work there. Anyone have some time today so I can get this tested and submitted?

WILBERT:

If I get a good test on this platform I'll send in a new package with those buttons I missed cleaned up and a few other things. Don't submit the one I sent....I'll link you to a new one if we get this sorted.

[blanius]

Chris I tried it as well and it didn't install corretly. I believe the problem is your are trying to create a database on the server and Most often that is not allowed. Many hosting pkgs only allow one db. You should just use existing DB (query user for db name) and then create tables prefixed with bbs or something to set them appart and not conflict with other possible tables.

[Chris_Seahorn]

OK. Pull it. Thanks for the confirm. I'll submit again.

[blanius]

Email if I can help in anyway.

[Chris_Seahorn]

Submitting the replacement this minute. I dropped the swf installer and have the user fill in the blanks in the "setup.php". I can't use a dump because I need them to choose an admin account so it has to be part of the setup.php one way or another (oh what a headache I have).

Wish I had taken the easy way out because that installer took forever to make and held me up all night testing it. Just learned a lesson.

Now I'm going to catch up on that life I set aside for two months.

[blanius]

LOL sorry Chris. Installing on servers is a complex business. I've seen a number of them have issues.

[blanius]

Chris it made tables, and you can login or register but the forums don't show.

http://bretlanius.com/bbs/

[Chris_Seahorn]

Sorry...passed out. I wonder If I code you a different frontend with loadVariables for the forum cats so we can test if you would try it for me? Just a matter of swapping the swf out if it's cool.

[blanius]

send it..

[Stoke Laurie]

Just did a test login as new user on brets board, will let you log in and recognises who you are but no forum output, hope that confirms your findings.

[Chris_Seahorn]

OK...building it now. Bret...can you smoke the exchange file? I'd rather we get something there more universal than how this is going. I'm making you a new one.

WHy those aren't showing has me baffled. Is it the scripted mask?...the loadvars?....hard for me since it works here. I'm falling back to the way I used to code forum dupes and will build you one of those to test.

[Chris_Seahorn]

Hey bret...yours looks like it wants to load. Inside the forumcats clip on frame 2 there is a stop command...delete that command and give it a try....it s on the same frame as the loadvars command before the loop on frame 9 that checks to see if forumCount is empty.

I think it's not getting past that command on commercial servers.
If not I also have a test with loadvariables but I think it's the stop command.

Each major section has one (forumcats,threads,posted clips). Either way I neeed to resubmit but this would help me see which to submit.

[Chris_Seahorn]

I PM'd you a link to a package with two new fun files and one new setup.php

One fun file is the loadVars type and one is the loadVariables type. The swf in the package is the exported loadVariables type. Hopefully one of these works for you...I have one confirm and two confirms respectively but want this to work for you.

[Chris_Seahorn]

I tried to submit the one with both flavors to the Exchange to update Bret but the file is too big (4.3 megs with two fun files) . I don't know what to do now and will have to either wait for you to reply that one or the other is working so I can drop one of the fun files inside to get the size down or I will haveto figure something else out.

Nobody else is jumping in to help so if you fail to help me or simply cannot get the forum to work properly...I'm gonna ask if the download can be removed since the one listed there now is prior to these fixes and I will have to buy commercial webspace to handle it myself.

[blanius]

Chris in frame 2 of forumcats is

code:

---

_root.tranny.gotoAndPlay("go");

 result_lv.forumCount="";

 var result_lv= new LoadVars();

    result_lv.onLoad = function(success) {

    if (success) {



     gotoAndPlay("cont");



      

    } else {

     

       // txt1.htmlText= "Error In The Follies Module!";



    }

    };

    var send_lv = new LoadVars();

    send_lv.action = "getcats";

  

    send_lv.sendAndLoad("./board.php", result_lv, "POST");

        }

---

[Chris_Seahorn]

I don't know man. I think everything happens for a reason and this is no different. Just leave it off the Exchange. I'm just going to use it as personal code and will revisit it when I'm back on a production server. Thanks for the tries.

I haven't heard back from Planet but will notify him of the same. It must only work here out of the box. I'm going to go back through my posts and remove references of myBBS as a download to avoid confusion since I won't be resubmitting.

Thanks to Wilbert too for the help.

[blanius]

Chris I think it's in the PHP code

I changed the line in board.php
//$action = $_POST["action"];
to
$action = $_GET["action"];

so I could test the board.php

I got an error on line 300 that fail was unsupported command. Changed line 300 for fail to die and now get database error!

[blanius]

GOT IT!!! line 297 in board.php

change
$query = "SELECT * FROM myBBS_forums ORDER BY displayOrder ASC";
to
$query = "SELECT * FROM mybbs_forums ORDER BY displayOrder ASC";

and it works.

[Chris_Seahorn]

That is code reused from other backends (one of my cms systems...fail is a function) . Change it to "exit;"

[Chris_Seahorn]

It's not the backends. You can direct hit them. Force an action:

action="getcats" will force the list of categories on direct hit (since it needs no other variables it's the quickest to force test for example)

depending on what action you force...and supply actual variables for if needed...you can test every section with direct hit. Thats not it though a good thought.

Since the coding is no different than every other mysql item i've submitted...I think this is Gods way of telling me something. Don't waste another minute on it Bret...really.

I wanted a forum...so I built one and I'm using it. I tried to share it but sometimes that can't be. Now I just want to move on after so much time stressing it.