Some problem with mod rewrite

[Quang]

Hi,
I have just upgraded my Vbulletin from version 3.7 to 3.7.3
After upgrading everythings is fine with PhotoPost classified, only the "Use Spider-friendly URLs" option does not work any more. If I turn it on, user can not visit the link anymore. if i turn it off, it is fine for visiting the links.
Could you please give your advice?
Thanks
Quang

[Chuck S]

Have you upgraded your server?

Spider Friendly urls totally depend on whichever apache version you have that one of these two variables is set for the domain

AcceptPathInfo On
AllowPathInfo On

[Quang]

Hi,
No, I did not upgrade the server. I only upgraded Vbulletion version from 3.7 to be 3.73 and launch mod rewite for Vbulletin forum.

I got email report from system:

========================
An error was encountered during execution of the query:

SELECT id,user,userid,cat,title,bigimage,views FROM mvproducts WHERE approved=1 AND status=0 AND cat IN (1,2,64,63,62,65,66,67,68,69,70,71,72,73,41,75,80,77,76,78,79,38,88,89,90,91,92,35,97,98,22,100,99,4,86,85,81,84,83,87,7,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,9,138,135,134,136,137,139,141,140,142,10,145,146,143,147,144,148,149,150,11,155,153,152,154,151,156,12,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,182,172,173,174,175,176,177,178,179,180,181,13,183,184,185,186,187,188,189,190,191,192,193,197,194,14,198,199,200,201,202,203,204,205,206,207,211,208,209,210,15,212,213,214,215,216,217,218,221,222,223,224,16,226,225,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,17,249,250,251,252,253,254,255,256,257,18,258,259,260,261,19,263,264,265,266,20,267,268,269,21,270,271,272,23,273,274,275,276,278,279,24,277,280,281,346,347,348,349,26,285,282,283,284,27,286,287,288,289,290,291,28,292,293,294,295,296,297,298,299,300,301,302,303,29,304,305,306,30,307,308,309,310,31,311,312,313,314,32,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,33,345,340,344,342,343,336,334,337,335,339,338,341,34,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,36,367,368,369,37,370,371,372,373,374,39,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,40,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,42,415,416,417,418,43,419,420,421,422,60) ORDER BY date DESC LIMIT 29

The query returned with an errorcode of:

MySQL server has gone away

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

========================
Thanks for your advice

[Chuck S]

well try turning off your mod rewrite does the spider friendly urls work?

MySQL server has gone away

That error tells you specifically your mysql server has shut down and does not indicate any issue with the software. Your mysql could have restarted encountered an error but at any rate mysql shut down on the server.

[Quang]

Hi,
I already turn it off. The mod rewrite still do not work.
It looks like I only receive the reporting emails if I turn the mo0d rewrite on. If I turn it off, it is fine.

I also got the other email if I turn mod rewrite on:

======================================
An error was encountered during execution of the query:

UPDATE IGNORE mvusers SET username='meetvietnam',laston=1227241155 WHERE userid=1 LIMIT 1

The query returned with an errorcode of:

Lost connection to MySQL server during query

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.

======================================

[Chuck S]

Well then your mod rewrite is affecting your mysql server