erland;227783 Wrote:
> 3.
> The SQL statements that causes everything to fail looks as follows:
> >
Code:
--------------------
> >
> INSERT INTO customscan_track_attributes
(track,url,musicbrainz_id,module,attr,value,valuesort,extravalue) SELECT
tracks.id,tracks.url,case when tracks.musicbrainz_id regexp '.+-.+'>0 then
tracks.musicbrainz_id else null
end,'mixedtag',customscan_track_attributes.attr,customscan_track_attributes.value,customscan_track_attributes.valuesort,customscan_track_attributes.value
from tracks,customscan_track_attributes where tracks.audio=1 and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag'
--------------------
> >
> When you have restored the backup you can connect with a standard SQL
> client of your choice and run this statement and see if the behaviour
> is reproducable this way. If the problem is reproducable this way,
> you might want to check the memory and diskusage during the
> operation.
Running the above using SQLyog returns:
Code:
--------------------
Error Code : 126
Incorrect key file for table '/tmp/#sql_f60_0.MYI'; try to repair it
(0 ms taken)
--------------------
Best I go searching for my.tt and see what's going on in there...
--
egd
Thecus N5200PRO >> Transporter >> ATC SCA2 >> ATC SCM100SLAT
------------------------------------------------------------------------
egd's Profile: http://forums.slimdevices.com/member.php?userid=3425
View this thread: http://forums.slimdevices.com/showthread.php?t=38256
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
