FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Problems with Puretec
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Problems with Puretec [message #7051] Wed, 06 November 2002 00:57 Go to next message
Micha37 is currently offline  Micha37   Germany
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 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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 #7053 is a reply to message #7051] Wed, 06 November 2002 08:50 Go to previous messageGo to next message
Micha37 is currently offline  Micha37   Germany
Messages: 77
Registered: October 2002
Karma: 0
Member
Hi Protoss,

you were exactly right and now I've got it back to work.

Actually I went over quota with my database, so they blocked it (without any announcement!!).

I think I will go hunting for another provider.

Best regards and thanks again

Michael
Re: Problems with Puretec [message #7109 is a reply to message #7053] Thu, 07 November 2002 18:34 Go to previous message
Olliver   Germany
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
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Anonymous Posting
Next Topic: Customizing FUD Forum
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 02:20:17 GMT 2024

Total time taken to generate the page: 0.02353 seconds