You are not enjoying the benefits offered by registering. To register click here...
  
Forums | Prefs | Your Messages | Members | Recent | Search
Quick Search


Advanced Search
| Calendar | Doc | Dev' Blog! |
Chat (Alpha Version)

Guest, do not forget to login ( Register )
 Top > Forums > This Software > Support, FAQ, How-to's
 Problem after installing

Skin Selection:
 (2 pages) 12  
NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 20, 2007, 10:30 pm by NextBBSHelp
Problem after installing
So knowing that those tables required MyISAM engine to run properly.  I set my database to only run off of MyISAM for a minute so that the database would install properly.  I am going to assume that the forums require MyISAM for their tables.  So only have two of them that way didn't work.
All of the tables install correctly and the rest of the wizard finishes up, but then I get another issue.  When I go to view my forums I get this issue:

Error
SQL Layer Error: Incorrect datetime value: '1179613186' for column 'us_lastupdated' at row 1
Query [INSERT INTO bb_uniquesessions (server,us_ID, us_lastupdated, us_data) VALUES ('1','2pd4ukeglbecfaf4v9sjiq3jd4', 1179613186, '')]

 
Can someone please help me?
 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 22, 2007, 3:08 am by chris
If the nightly build does not work for you, try this:

1- Open user.php

2- Find:
php Code:
  1. $qry = "INSERT INTO {$CONFIG->dbprfx}uniquesessions (server,us_ID, us_lastupdated, us_data)
  2.                        VALUES ('{$CONFIG->server}','$aKey', ".$COMMON->now().", '')";


3- Replace with:
php Code:
  1.                 $qry = "INSERT INTO {$CONFIG->dbprfx}uniquesessions (server,us_ID, us_lastupdated, us_data)
  2.                         VALUES ('{$CONFIG->server}','$aKey', '".date("Y-m-d H:i:s")."', '')";


4- Save and try again.

Thanks,
-C.

 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 22, 2007, 3:09 am by chris
Oh, BTW, you should find these lines around line 706 of user.php

 
Top

NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 22, 2007, 11:48 pm by NextBBSHelp
Wow, this is fun...Error after error.  Now this comes up:

Error
Error type: E_NOTICE
Message: Undefined variable: isclass_based
Location: F:\Apache2\htdocs\highc\forum\main.php (line: 359)


It is on the site just like before.

 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 23, 2007, 4:15 am by chris
Ack. Fixed in tomorrow night's build, or you can retrieve a new main.php from trac.

Sorry about that, we have not had the chance to test every possible php configuration. But we are certainly making progress!

 
Top

NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 24, 2007, 1:15 am by NextBBSHelp
Nice, that's what a beta is for!  Ok, well what/who is trac?
 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 24, 2007, 2:11 am by chris
www.nextbbs.com/trac/nbbs/browser

Always the freshest code. Always

 
Top

NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 24, 2007, 6:47 pm by NextBBSHelp

Ok, so I did what you said Chris and that error went away, but there is a new one now.  Similar to the previous one. Here it is:

Error type: E_NOTICE
Message: Undefined variable: CONFIG
Location: F:\Apache2\htdocs\highc\forum\common.php (line: 2976)

Just like before if you want to see it in action.  It is on my site. My version of MYSQL is 5.0.37 just incase you forgot and my PHP version is 5.2.2.


 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 25, 2007, 1:25 am by chris
Ouch. This time PHP5 actually found a piece of code that could have used more rigorous import statements.
You should be able to retrieve a fixed version from the nightly build or www.nextbbs.com/trac/nbbs/browser/common.php

Thank you for your patience!

 
Top

NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 26, 2007, 4:47 am by NextBBSHelp

Lol, thanks...You must be annoyed of me finding all of these glitches...Alas, I have more.

There are actually three (3) of them.  One results if I got to my server on my local network here it is:

Error type: E_NOTICE
Message: Undefined index: haszointsprofile
Location: F:\Apache2\htdocs\highc\forum\user.php (line: 249)

The only two occur from outisde...When others actually view my site.  Sorry, they are to big to copy and paste here.  So link.  They are at the top and bottom.  One is another yellow box like before.  The other I believe is PHP not writing the correct stuff out.


 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 26, 2007, 5:46 pm by chris
OK I fixed 'haszointsprofile' in svn/trac.

Regarding the two other ones, let's focus on the top one: it seems to be saying that your language file is improperly formed, like, for instance, missing its '<?php' top line.

 
Top

araujomarcelo


Newbie
Group: Members
Posts: 4
Reputation: 0


Posted on May 26, 2007, 8:16 pm by araujomarcelo
Some Debug Info
Hi all,
I don't know why, but the following error occurs when "this->total_queries" is equal to 16. In this moment, $CONFIG is forced to NULL.
Can it be caused by PHP  loss of variable?  I think  it's possible.

If anyone know more about...
Error type: E_NOTICE
Message: Trying to get property of non-object
Location: C:\Program Files\Apache224\htdocs\NextBBS\dbdriver.php (line: 89)

 
Top

NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 27, 2007, 3:48 am by NextBBSHelp

Yeah, what about the one at the bottom Chirs?

Error type: E_NOTICE
Message: Trying to get property of non-object
Location: F:\Apache2\htdocs\highc\forum\dbdriver.php (line: 89)

Also, the one at the top is not because of the <?php tag.  I know it is something with my configuration.  Other servers such as the people on here run it fine.


 
Top

NextBBSHelp


Wannabe
Group: Members
Posts: 25
Reputation: 0


Posted on May 29, 2007, 3:15 am by NextBBSHelp

Chirs are you going to addres the above issue at all?


 
Top

chris

The Culprit
Group: Admins
Posts: 1,511
Reputation: 38


Posted on May 29, 2007, 3:42 am by chris
Obviously I intend to fix it, of course.

araujomarcelo, good job spotting the query number.
Does this happen when displaying any page or a specific page?

Sorry that this takes longer than usual, but this is always more difficult to resolve when it's something that I cannot reproduce.
Thanks for your help, guys.

 
Top

 (2 pages) 12 - Flat Mode | Threaded Mode  
Quick Jump:

         
Page generated in 0.03 seconds (Queries: 0.00) - Cpu: 0.70
Total DB [adodb:mysql] queries: 14
Total Strings Translated: 12
Powered by NextBBS SE v0.4.5 - Copyright © 2007 CFR & The NextBBS Team
Chatbox powered by smiletag