Loading...
 
Architecture / Installation

Architecture / Installation


Rescue Tiki Install! (was: Internal Server Error)

posts: 16

Dear all

This thread relates to the "Internal Server Error" http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=11712&topics_threshold=0&topics_offset=3&topics_sort_mode=lastPost_desc&topics_find=&forumId=6 but I am a little bit further, so the problems are different now wink Thanks to Damian and Sylive for the tips in the other thread!

Brief summary

  • On http://www.yesalumni.net are two Tiki installations, a live and a test one.
  • For some unknown reason the live install does not work anymore giving a "Internal Server Error". (Apache Error logs, etc. are in the thread linked to in the box above).
  • The test install works fine.

What I did

  • I connected the live-db with the test-Tiki (by copying local.php, nothing else) hoping that it would work together fine. It did not. neutral
  • The correct tiki-index.php was displayed but after I tried to log in, I get 1000s of these errors:
Notice: Undefined offset: 10 in /opt/root/home/yesalumninet/public_html/test/modules/mod-forums_last_posts.php on line 16

Notice: Undefined offset: 11 in /opt/root/home/yesalumninet/public_html/test/modules/mod-forums_last_posts.php on line 16

...

AFAI understand, this is a buffer overrun in the module "Forum Last Post"...correct?

My questions

  • To transfer an existing db to a nother Tiki install (of same version), is it enough to reconnect (local.php) or are additional configs needed?
  • Would deactivating the module "Forum Last Posts" solve the problem? How can I deactivate it from outside Tiki? I can access the db via phpMyAdmin, I can also access *.php via ssh.
  • Sylvie said something about php being inside CGI-bin as a reason for the above "undefined offset" error. Sorry I do not quite understand. My /cgi-bin/ is empty. confused And in addition, the test site worked last time I checked; and both are with the same provider...
  • If I cannot remove the mod "Fourm Last Posts" easily, how can I fix the overrun? Where in the database do I have to search?
  • Would direct access to tiki-admin-modules.php help? Although via the browser, I do not get access... It says: CGIWrap Error: Execution of this script not permitted — Script is not a regular file


Thanks to all of you!
madmaxx


posts: 16

Thanks, Damian.

I do not intend to waste time, neither mine nor yours biggrin — I just do not understand why it does not work consistently... I sent a ticket to the host asking about the PHP memory limit and the CGi-wrapping. Will see...
The host is www.guest.hosting.ch (Switzerland)

Thanks a lot for your time,
madmaxx

posts: 2881 United Kingdom

Its not one that I know about on the Friendly Hosts list and it wont resolve into a site anyway.

The intermittancy is caused by a varing degree of memory being used to generate each page. For example looking at a tiki site, check the bottom status bar and you'll see it changes between each page load.

Having said that doing that exercise on either tikiwiki.org or any of mine is not a good comparision as we both run Turck-mmcache which reduces the amount of memory consumed.
Compare it the number of database queries for each page. Each page uses a different number of queries.

--
Damian
Damosoft - TikiWiki Development/Hosting Services


posts: 1092

You can take away a displayed module by removing the line in tiki_user_assigned_modules (name = module name)

You can play with local.php like you did. But the 2 tiki versions must have the same model (otherwise you have to run db/tiki_1.8to1_9 to go the upper version and you can't go back) You can check if the 2 versions are identical by comparing db/tiki.sql in both. Verions is not 1.8 or 1.9 but it is the cvs date ....

posts: 16

Thanks Sylvie.
The CVS versions are identical but the error persists.

Thanks Damian.
I contacted the provider...
- They do CGI-Wrapping since 2 weeks and they will not deactivate it. So, this is already a knock-out for running Tiki there, correct?
- BUT he wrote that the server error was there BEFORE the wrapping got installed. This means the causes for the error are somewhere else, no?
- He checked memory_limit and tested it with 40M. Did not work.
- The error persists until one exits the browser and starts again. Which makes him wonder... (and me too).

I switched back from my hack with exchanging the local.php from the live and the test install... The test install works fine! idea

I have in mind to change the provider (because of the CGI-Wrapping) but I fear that the error will persist. Is it possible that the mySQL db has some entries which lead to the Apache server error? And when moving, I will obviously use the same db over there...

Thanks for any additional idea you might have!
madmaxx

posts: 2881 United Kingdom

They do CGI-Wrapping since 2 weeks and they will not deactivate it. So, this is already a knock-out for running Tiki there, correct?

Yes it will never run correctly


He checked memory_limit and tested it with 40M. Did not work

with cgi-wrapping it doesnt matter what the memory limit is set to, it will always run out.


The error could be connected to browser sessions, but without details from the error.log and the ability to add debugging into the code, I have no idea.

Damian
TikiWiki Development/Hosting/Support Services

posts: 16

Oh oh...

I just found that the table tiki_user_assigned_modules contains zero rows!

This looks very bad cry — Is there any way to build the table manually?
Or do I have to rescue as much data as possible and start from an empty Tiki install?

madmaxx

posts: 1092
If you don't find an entry in tiki-assigned... you can go and delete the line in tiki_user_modules
posts: 16

Oh Oh Oh... frown

phpMyAdmin tells me:

  • Table tiki_user_modules running on localhost has 0 rows.
  • Table tiki_user_assigned_modules running on localhost has 0 rows.
  • Table tiki_modules running on localhost has 8 rows.; and looks like this:
"login_box";"l";"1";NULL;;"0";"0";;"a:1:{i:0;s:9:\"Anonymous\";}"

"application_menu";"l";"5";NULL;;"0";"0";;"a:1:{i:0;s:9:\"Anonymous\";}"
"search_box";"r";"1";NULL;;"0";"0";;"a:1:{i:0;s:9:\"Anonymous\";}"
"online_users";"l";"3";NULL;;"0";"5";;"a:4:{i:0;s:12:\"Participants\";i:1;s:10:\"Moderators\";i:2;s:7:\"Alumnus\";i:3;s:6:\"Admins\";}"
"forums_last_posts";"r";"4";NULL;;"0";"10";;"a:4:{i:0;s:12:\"Participants\";i:1;s:10:\"Moderators\";i:2;s:7:\"Alumnus\";i:3;s:6:\"Admins\";}"
"shoutbox";"r";"2";NULL;;"0";"2";;"a:4:{i:0;s:12:\"Participants\";i:1;s:10:\"Moderators\";i:2;s:7:\"Alumnus\";i:3;s:6:\"Admins\";}"
"messages_unread_messages";"l";"2";NULL;;"0";"3";;"a:4:{i:0;s:12:\"Participants\";i:1;s:10:\"Moderators\";i:2;s:7:\"Alumnus\";i:3;s:6:\"Admins\";}"
"last_modif_pages";"r";"3";NULL;;"0";"10";;"a:4:{i:0;s:12:\"Participants\";i:1;s:10:\"Moderators\";i:2;s:7:\"Alumnus\";i:3;s:6:\"Admins\";}


That does not look good. I am currently checking if I can get a pre-incident-backup of the database.

madmaxx


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting