Problems with Puretec [message #7051] |
Wed, 06 November 2002 00:57 |
Micha37
Messages: 77 Registered: October 2002
Karma: 0
|
Member |
|
|
Hi there,
it seems that today my provider did some changes (dont know which) but suddenly my Fudforum does not work.
I tried to rebuild Forums consitency but the result is below error message and the forum stays looked, even if I surely unlooked the the forum files.
Anyway, it seems that the problem is caused by Puretec as I even can not optimize any of my SQL tables in the phpmysqladmin.
If you have any advise, I would really appreciate.
Best regards
Michael
Here is the consitancy rebuild report:
Quote: | Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
OK
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
1 entries unmatched, deleted
Checking read table against users
OK
Checking read table against topics/messages
OK
Checking file attachments against messages
Done: Checking file attachments against messages
Checking attachment counts in messages
Done: Checking attachment counts in messages
Checking polls against messages
OK
Checking message reports
OK
Checking poll tracking against poll options, users
OK
Checking if all poll options belong to existing polls
OK
Checking all poll tracking against polls
OK
Checking for messages against polls
OK
Checking topics forum relations
OK
Checking message topic relations
OK
Checking smilies against disk files
OK
Checking disk files against smilies
OK
Checking Approvals
Done: Checking Approvals
Updating counts for topics
threads updated
Updating forums
Updating topic counts for forums
Forum: CT/ICT
thread count:6
post count:65
Forum: Pumpe
thread count:3
post count:15
Forum: Technik
thread count:4
post count:32
Forum: Ernährung
thread count:15
post count:118
Forum: Psychologie
thread count:2
post count:22
Forum: Forschung
thread count:2
post count:12
Forum: Dies & Das
thread count:15
post count:167
Forum: Kinder/Jugendliche
thread count:2
post count:11
Forum: Fragen
thread count:3
post count:8
Forum: Eure Meinung
thread count:3
post count:29
Forum: Diabetes Typ 3 MODY
thread count:2
post count:21
Forum: Für anonyme Besucher
thread count:1
post count:4
Forum: Folgeerkrankungen
thread count:1
post count:9
Forum: Der neue Chat
thread count:3
post count:19
Forum: Fragen/Antworten
thread count:2
post count:2
Forum: Testforum
thread count:1
post count:1
Forum: d.s.m.d.
thread count:0
post count:0
Updating post counts
finished forum counts
Checking topic notification entries against users
OK
Checking topic notification entries against topics
OK
Checking forum notification entries against users
OK
Checking forum notification entries against forums
OK
Updating Topic Last_Post_Id Field
Done: Updating Topic Last_Post_Id Field
Updating Forum Last_Post_Id Field
Done: Updating Forum Last_Post_Id Field
Checking email notification entries against topics
OK
Checking topic votes against topics
OK
Checking topic votes against users
OK
Rebuilding Topic Views
() 1044: Access denied for user: 'p6827030(at)infong42(dot)kundenserver(dot)de' to database 'db28028815'
Query: INSERT INTO fudforumthread_view (thread_id,forum_id,page,tmp) SELECT fudforumthread.id, fudforumthread.forum_id, 4294967294, CASE WHEN is_sticky='Y' AND (fudforummsg.post_stamp+fudforumthread.orderexpiry>1036544279 OR fudforumthread.orderexpiry=0) THEN 4294967294 ELSE fudforumthread.last_post_date END AS sort_order_fld FROM fudforumthread INNER JOIN fudforummsg ON fudforumthread.root_msg_id=fudforummsg.id WHERE forum_id=2 AND fudforummsg.approved='Y' ORDER BY sort_order_fld DESC, fudforumthread.last_post_id DESC
Server Version: 3.23.51-Max-log
|
|
|
|
Re: Problems with Puretec [message #7052 is a reply to message #7051] |
Wed, 06 November 2002 01:22 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
It seems your provider has taken away you CREATE/DROP TABLE priveledges for the forum account.
FUDforum Core Developer
|
|
|
|
Re: Problems with Puretec [message #7109 is a reply to message #7053] |
Thu, 07 November 2002 18:34 |
Olliver
Messages: 443 Registered: March 2002
Karma: 0
|
Senior Member |
|
|
Hi Michael,
Puretec is painful to setup because of another reason: U can only use scripts compiled with zlib support because else the script won't execute because it's too large. this means u have to be familiar with setting up cvs. May not apply to all windows users. Another disadvantage is php running as cgi, the server never takes ownership of the files, hence no advanced secure settings are possible. The biggest of them all: puretec uses a dedicated (=standalone) sql-server. this means they can only use tcp as protocol for comunication which considerably slows down things, compared to a local UNIX domain-socket. In case u re still looking for a German quality hoster, try http://www.hoster24.de
bye
Olliver
|
|
|