SQL errors

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
japagun
Valued Contributor
Posts: 52
Joined: 1. February 2009 09:50
phpBB.com User: japagun

SQL errors

Post by japagun »

Your Portal Version: 1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Advanced Knowledge
Boardlink: [url]http://localhost%20sorry[/url]

What have you done before the problem was there?
nothing, just finished the languague translation, and tried to update the DB to the version 3.0.4 i didn't have success, if i tried to enter in index.php, everything is gone fine....... but when i click in portal, or type portal.php in my browser, i have errors with mysql....

What have you already tryed to solve the problem?
searched here, but nothing help me yet

Description and Message
tried to update the DB to the version 3.0.4 i didn't have success, if i tried to enter in index.php, everything is gone fine....... but when i click in portal, or type portal.php in my browser, i have errors with mysql....

Code: Select all

SQL ERROR [ mysql4 ]

Error writing file '/tmp/MYP5T7uS' (Errcode: 28) [3]

SQL

SELECT topic_title, forum_id, topic_id FROM phpbb_topics WHERE topic_status <> 2 AND topic_approved = 1 AND topic_type = 0 AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: portal/block/recent.php
LINE: 122
CALL: dbal->sql_query_limit()

FILE: portal.php
LINE: 80
CALL: include('portal/block/recent.php
[/i]

Topic author
japagun
Valued Contributor
Posts: 52
Joined: 1. February 2009 09:50
phpBB.com User: japagun

Re: SQL errors

Post by japagun »

up
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: SQL errors

Post by Kevin »

Are you working with a local server, like XAMPP?
Error writing file '/tmp/MYP5T7uS' (Errcode: 28) [3]
This points to missing writing access for temp files / wrong directory permissions. So i guess you need to edit your server configuration.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
japagun
Valued Contributor
Posts: 52
Joined: 1. February 2009 09:50
phpBB.com User: japagun

Re: SQL errors

Post by japagun »

Kevin thanks for your reply, but did you know where i can set this configures???? When i activate the wordgraph, the same errors appears......
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: SQL errors

Post by Kevin »

Just tick the magic switch.
Maybe i can say more as far as i find my glass bowl. ;)

Seriously: with the information you gave at this time, i can say nothing. You haven't even answered my last question.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
japagun
Valued Contributor
Posts: 52
Joined: 1. February 2009 09:50
phpBB.com User: japagun

Re: SQL errors

Post by japagun »

i didn`t saw your reply above sorry...
Yes i`m using xampp
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: SQL errors

Post by Kevin »

So this is the only hint i have for you:
Kevin wrote:
Error writing file '/tmp/MYP5T7uS' (Errcode: 28) [3]
This points to missing writing access for temp files / wrong directory permissions. So i guess you need to edit your server configuration.
This is definitely a XAMPP / Windows configuring issue.
Please refer to the belonging support forum.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
japagun
Valued Contributor
Posts: 52
Joined: 1. February 2009 09:50
phpBB.com User: japagun

Re: SQL errors

Post by japagun »

Kevin wrote:So this is the only hint i have for you:
Kevin wrote:
Error writing file '/tmp/MYP5T7uS' (Errcode: 28) [3]
This points to missing writing access for temp files / wrong directory permissions. So i guess you need to edit your server configuration.
This is definitely a XAMPP / Windows configuring issue.
Please refer to the belonging support forum.
I`ll see if i have any answers from their....thanks for now....
Locked

Return to “board3 Portal 1.0.x - English Support”