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

Home » FUDforum » FUDforum Installation Issues » 2 errors: symlink() and Table 'fudforum._level' doesn't exist (I get error messagesof 2 kinds while installing the forum on a drive connected by CIFS)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165156] Wed, 04 May 2011 12:57 Go to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

The 1st is the error

PHP Warning: symlink(): Operation not supported in /www/kisekimanga/FUDforum/include/glob.inc on line 163



Another is

FATAL ERROR!
Failed to load seed data into table def_levels:<br />Query: INSERT INTO _level (name,post_count) VALUES ('Senior Member',100)<br />SQL error: 1146: Table 'fudforum._level' doesn't exist @ INSERT INTO _level (name,post_count) VALUES ('Senior Member',100)

(_ is a table prefix)

What do I do wrong?
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165157 is a reply to message #165156] Wed, 04 May 2011 13:03 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Forum & PHP versions?
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165158 is a reply to message #165157] Wed, 04 May 2011 13:07 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

forum - 3.0.2, just downloaded,
php 5.3.6
mysql 5.5.11

forum db driver: mysql/mysqli (error with both)
the tables in the database are created, except of %prefix%level

[Updated on: Wed, 04 May 2011 13:12]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165159 is a reply to message #165158] Wed, 04 May 2011 13:11 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Definitely a bug.

Workaround would be to enable symlink() for your PHP installation.
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165160 is a reply to message #165159] Wed, 04 May 2011 13:15 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

Well, the error is not in PHP, but in CIFS file system that does not support symlinks.
The files are actually on the NTFS partition (the server runs in a virtual machine).
Windows does not have them.

[Updated on: Wed, 04 May 2011 13:32]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165161 is a reply to message #165160] Wed, 04 May 2011 13:32 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

Ok, I see function fud_symlink($src, $dest). Is there an unpacked installation package I could hack?


What about the bug with a %prefix%level table?
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165162 is a reply to message #165161] Wed, 04 May 2011 13:41 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
You can build your own installer.

For instructions, see Installation (section: Create your own install script).
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165163 is a reply to message #165162] Wed, 04 May 2011 15:40 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

sorry, but the page Installation you point does not have that section
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165164 is a reply to message #165162] Wed, 04 May 2011 15:41 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Here is a proposed patch for the symlink issue:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5231&view=rev

I was able to install FUDforum with a table prefix of '_'. I suspect '_level' may be a reserved word in newer MySQL versions. A quick workaround is to use a different prefix.
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165165 is a reply to message #165163] Wed, 04 May 2011 15:43 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
grigori wrote:
sorry, but the page Installation you point does not have that section


It is there. Look carefully and click on "show" to see the details.
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165166 is a reply to message #165164] Wed, 04 May 2011 15:44 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

thanks, I found it, will try now

[Updated on: Wed, 04 May 2011 16:16]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165167 is a reply to message #165166] Wed, 04 May 2011 18:51 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

I compiled a custom installation pack.
The symlink is fixed.

When it sets up the database it issues another error:

Failed to load seed data into table def_mime:
Query: INSERT INTO fud30_mime (fl_ext,mime_hdr,descr,icon) VALUES('aiff','audio/x-aiff','AIFF File','sound.gif')

SQL error: 1146: Table 'fudforum.fud30_mime' doesn't exist @ INSERT INTO fud30_mime (fl_ext,mime_hdr,descr,icon) VALUES('aiff','audio/x-aiff','AIFF File','sound.gif')

Now it can't create table 'fudforum.fud30_mime' Confused

[Updated on: Wed, 04 May 2011 19:02]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165168 is a reply to message #165167] Thu, 05 May 2011 02:55 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Strange that it fails on an INSERT and not on the CREATE. Can you debug the relevant section in install.php to see why the table isn't created?

PS: Have you checked out the 3.0.2 branch? You are welcome to check out trunk, but then you should expect a couple more bugs.
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165171 is a reply to message #165168] Thu, 05 May 2011 07:01 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

Looks like there is some unrelated error in listing files in a folder, sorry.

[Updated on: Thu, 05 May 2011 08:01]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165173 is a reply to message #165171] Thu, 05 May 2011 11:46 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

I found out that listing of a folder on a partition mounted by CIFS does not show more then ~40 entries (files/folders)
Both `ls` or a glob() function - this looks like a filesystem problem.
If I move visible files to another folder, it starts showing the other 40.
The direct access to the file by name works fine, but the script just can't find all files in a folder - and create all tables in DB.

I don't really know a solution, other then to try to use a newer Linux, this one is quite old one, or make a file with the folder listing and get its contents instead of calling glob().

[Updated on: Thu, 05 May 2011 11:50]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165174 is a reply to message #165173] Thu, 05 May 2011 12:16 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Will it help if we replace the glob() with opendir() and readdir() calls?
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165175 is a reply to message #165174] Thu, 05 May 2011 13:30 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

sad, but no

I created 2 text files with lists in windows:
W:\FUDforum\sql>dir /b *.sql >sql.txt
W:\FUDforum\sql>dir /b *.tbl >tables.txt

replaced glob() in install.php with
$tbl = file($DATA_DIR .'sql/tables.txt',FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES );
$sql = file($DATA_DIR .'sql/sql.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES );

and
foreach ($tbl as $t) {
$t = $DATA_DIR .'sql/'.$t;
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165176 is a reply to message #165175] Thu, 05 May 2011 13:51 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

maybe it would worth to join all table definition in 1 file?
inconvenient for development, of course Confused

[Updated on: Thu, 05 May 2011 13:51]

Report message to a moderator

Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165177 is a reply to message #165176] Thu, 05 May 2011 14:37 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
grigori wrote:
maybe it would worth to join all table definition in 1 file?
inconvenient for development, of course Confused


That would be a good workaround, but not a permanent solution.

Where can I read more about the +-40 file limit on CIFS file systems?
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165178 is a reply to message #165177] Thu, 05 May 2011 17:21 Go to previous messageGo to next message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

I don't know, I found it out while debugging the error. Maybe it was fixes already, I'll try to google.

There is the same problem with the theme\default folder. Only 41 files were copied.
Looks like it's not easy to set this forum to a network drive Smile
Re: 2 errors: symlink() and Table 'fudforum._level' doesn't exist [message #165179 is a reply to message #165178] Thu, 05 May 2011 18:44 Go to previous message
grigori is currently offline  grigori   
Messages: 15
Registered: June 2007
Location: Ukraine
Karma: 0
Junior Member

I found several bug reports about it, e.g.
https://bugs.launchpad.net/ubuntu/+source/samba/+bug/406466/comments/43
http://ubuntuforums.org/showpost.php?p=8880240&postcount=1

it looks solvable to some people by an option passed to mount, but it does not work for me
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Consistency check after import from source forum
Next Topic: canĀ“t install: Warning: gzuncompress()
Goto Forum:
  

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

Current Time: Thu Nov 21 16:01:42 GMT 2024

Total time taken to generate the page: 0.04356 seconds