help request: page not found after transfer

i've google searched countless possible strings trying to find the answer to this question but have not revealed anything useful except for cronjob setup (which i forgot to do initially) but it didnt solve my problem. This question is for advanced dolphin users, most likely...

After a host transfer FROM ubuntu 12.10 to CentOS 5 w/ kloxo, i have corrected all of the settings as per forum posts here and the faq, openbasedir disabled, permissions, editing the header.inc.php, setting permissions, etc... and even set up the cronjob which i forgot to do in the beginning. Here lies the problem: **on all of the content created BEFORE the transfer in the modules: news (module UltimateNews by modzzz), Events (boonex), Groups (boonex), everything shows up "Page not Found." However, on content posted AFTER, new stuff shows just fine.

Photos, articles, files, sites, and forums (all boonex) are unaffected (no videos have been uploaded, have yet to test).

Here's the odd part: URL's created in news prior to transfer were assigned automatically using the title such as "News-Title-is-Here" but new content post-transfer is showing up awkward such as "-N" or "-" or "P" and I have no idea why. Because of this, old content is now null and void and would have to be re-created to work properly, which is the only fix i personally can come up with.

Any suggestions?

More information: all items in Host Tools under admin panel are green except php upgrade version (currently 5.2.17), and this: thread_cache_size = 0 - FAIL (must be > 0) which i set manually but still shows red... beats me. I took the site offline during the transfer and copied all files, and uploaded to new server in binary mode, and dumped the SQL to upload into new server, then edited header.inc.php, and set all the config requirements in php.ini in /etc/php.ini for global change, then edited /home/apache/mywebsite/php.ini for the per-user ini file. The config changes appear correct in the Host Tools, and the cronjob is set up in kloxo CP as "php -q /home/myname/mysite/periodic/cron.php" and set to run every minute.

Quote · 18 Feb 2013

Because you stated old posts are not working but new ones are that rules out the most common problem of htaccess rewrites.

So i have two other possibilities i can think of.

1) After the site was transferred, did you empty the contents of the cache, cache_public and tmp folders? If not, then that could be a problem.

2) Backup and restore of the database did not preserve database collation. Normally database tables and the text fields within each table should be using utf8_general_ci as the collation. I would check your old database and compair the collation from the old one and the new one. That is if you still have access to the old database.


https://www.deanbassett.com
Quote · 18 Feb 2013

i emptied all 3 folders you mentioned, no progress.

i do have the old database as i had my site hosted on my own server in my house, so it is still there. i access it using HeidiSQL and under the table in Options tab, it shows that collation you mentioned, and checked it against the new database on the VPS, and it shows the same thing. That is, if i looked in the right place...

EDIT: i can provide login details if needed for both hosts, as well as a url to the site if you wish to dig further, might help a future dolphin user if they swap hosts

Quote · 18 Feb 2013

Your problem is strange.....

Run this on your database and check the collation of "uri" column

SHOW FULL COLUMNS FROM `bx_groups_main`;
If its "utf8_general_ci" then need your phpmyadmin login to check further.

so much to do....
Quote · 18 Feb 2013

thats what they show up as, some say (null) but likely because they're empty, im not that good with SQL, i only know my way around. ill PM you with some login info

Quote · 18 Feb 2013

I looked at your site and all files and folders permissions are 777. Well thats not good. Its messed up badly, did you unziped the file or modified the directory of your site user while logged as root, or you were trying to make them 777 for some reason. I have no idea how you setup your server.

oh and file permissions should be 644 and folders should be 755 in most cases. 

so much to do....
Quote · 18 Feb 2013

i uploaded all of the files off my old server using winscp since at the time, ftp wasnt working, and then i executed this in putty:

http://www.boonex.com/forums/topic/Dolphin-7-and-installation-permissions.htm

it was a transfer from one server to another and yes i was in root when i executed it, then used 
chown devilzeye:apache -R * while in the site dir but apparently the group didnt stick, it reverts back to devilzeye:devilzeye every time 

Quote · 18 Feb 2013

i just tried to chmod to 755 as you stated, but the site failed to open module articles, the only one i tried. ill try to chmod to 775 and see if that fixes it instead.

UPDATE: ok 775 works, because of the way my server is, kloxo on centos, i have to have 775 because the group apache has to write, as the owner is my username.

on a side note, now that i've been screwing with it trying to fix the url's, now i get this all over the site:

Warning: curl_exec() has been disabled for security reasons in /home/devilzeye/gamerscove.net/inc/utils.inc.php on line 1160

i've fixed that once before i think, ill work on that now.

never fails with dolphin, fix one thing, another pops up... ugh 

Quote · 18 Feb 2013

ok so i got the curl error to go away, kloxo reset my php.ini file to disable it in the paramaters... starting to regret using kloxo, because i strongly believe it is the cause of my URL issues on my old content, as it would be the only logical explanation. Everything worked great on my Ubuntu server...

Just uploaded a "TEST VIDEO" on my site (thats the title), after setting up the cron job. it was successful, and the URL showed up as this: ".../m/videos/view/-" and i don't get why it doesn't use the title anymore like it used to. I copied the list of perm chmod's from the link earlier to a text file and search/replace to 775 (minus ffmpeg.exe) and ran that on my SSH terminal. It still just used a "-" for the content, so perms isn't the issue.

Any one else wanna tackle my problem with me? lol

Quote · 18 Feb 2013

ok then, suppose ill start re-creating all of the content over the next few days.

Quote · 20 Feb 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.