Feed Preview
 

 
No.
nuken wrote:
It is hard to find extra time to work on a project that takes away from family. It seems the older I get, the more I have to do and the less time I have in a day to do it.


man that is the truth.

it does feel like it was just yesterday when I had tons of time for all my projects. now i have all the stuff i have to do and no time to do it
Nope, you have to build a new bbcode based on a copy of the old one like: [urlself][/urlself]
Rolling Eyes
After your reply:

neralex wrote:
mike63740, it seems that the image-paths are not not correct


I search the paths of the files for errors.

Old path: http://localhost/Images/photo1.png

New path: http://localhost/RavenNukeV2.51/Images/photo1.png

Everything looks great. Thank you.
Note: I noticed that the mysql-functions are removed in php7 - it's supporting mysqli only. That means the whole INSTALLATION process is broken with this version! I'm working on a package for RavenNuke 2.5.1, which will work also with php7. For a fresh installation please don't use it as long the new package is released.

I come closer to some SQL-Errors, which returns while using mysql 5.6+. Some important default-values has been changed.

Some new defaults are based on the TIMESTAMP and DATETIME improvements. That means, default-values like '0000-00-00 00:00:00' for DATETIME fields or '0000-00-00' for DATE fields are not more allowed. The supported range is '1000-01-01' to '9999-12-31'. This affects some queries in the INSTALLATION process (already fixed in my package) and it needs a big check to all affected modules with related INSERT queries.

http://dev.mysql.com/doc/refman/5.7/en/datetime.html
http://mysqlblog.fivefarmers.com/2012/05/29/overlooked-mysql-5-6-new-features-timestamp-and-datetime-improvements/

The 2nd big one is the default: sql_mode=only_full_group_by

Here an example of the Forums index:

Code:
SQL Error : 1055 Expression #29 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rn251php7.t.topic_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_id, t.topic_title FROM ((( nuke_bbforums f LEFT JOIN nuke_bbposts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN nuke_users u ON u.user_id = p.poster_id ) LEFT JOIN nuke_bbtopics t ON t.topic_last_post_id = f.forum_last_post_id) GROUP BY f.forum_id ORDER BY f.cat_id, f.forum_order


Here is the full query:

php Code:
$sql = "SELECT f.*, p.post_time, p.post_username,  u.username, u.user_id, t.topic_id, t.topic_title

FROM ((( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_last_post_id = f.forum_last_post_id)
GROUP BY f.forum_id ORDER BY f.cat_id, f.forum_order";


After checking the mysql-docs I figured it out, that the field t.topic_id must be placed also in the GROUP BY clause.

https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by

php Code:
$sql = "SELECT f.*, p.post_time, p.post_username,  u.username, u.user_id, t.topic_id, t.topic_title

FROM ((( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_last_post_id = f.forum_last_post_id)
GROUP BY f.forum_id, t.topic_id ORDER BY f.cat_id, f.forum_order";
This I like:

Guardian2003 wrote:
I have no need for multiple different Forum add-ons so I'm quite happy to use what currently ships with RN and wait for whatever the RN Team decide to use.


I hoped this was the case with phpBB 2.0.23:

neralex wrote:
The used phpBB-version in RN is a highly modified/patched bridge between the CMS and the forums-software. Its working well and its secured as possible.

In short: leave as it is - it's fine.


Valuable and comforting information:

Guardian2003 wrote:
The Nuke Resources website looks like it has changed ownership so you can safely ignore those version messages.
The ported (modified phpBB form) used in RavenNuke (tm) 2.5x is as safe and stable as we can make it and should work for a long time to come if there are no significant changes to the PHP programming language it uses.


Thank you all. Confused
Still not but isn't really grave. (sentinel should be desactived and not sending mails but it's not a big problem)
Cheers
Maybe it helps...

http://rnwiki.ravennuke.com/wiki/RavenNuke2:Installation
 

Subscribe


Add to Google
Add to My Yahoo!
Add to My AOL
Add to My MSN
Subscribe with Bloglines
Add to netvibes
Subscribe in NewsGator Online
Subscribe with PageFlakes
Subscribe in Rojo
Add this site to your Protopage
Add to Newsburst
Subscribe in NewsAlloy
Add to Blogarithm
Ravens PHP Scripts And Web Hosting Forums in ATOM 1.0 format
Ravens PHP Scripts And Web Hosting Forums in RSS 0.91 format
Ravens PHP Scripts And Web Hosting Forums in RSS 2.0 format


Valid Atom 1.0
Valid RSS
 

Site Info v2.2.2

Last SeenLast Seen
Server TrafficServer Traffic
  • Total: 342,298,832
  • Today: 23,459
Server InfoServer Info
  • Nov 21, 2017
  • 07:31 am PST
 
 

Daily Inspiration