 |
 |
 |
 |
Registered: 07/07/05
Posts: 62
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#182398 - 04/10/07 01:08 PM
Image permission error on import?
|
member
Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
|
Forced classic to v7.1 threads import, because the new PHP broke php on classic 672.  Win2k3 server, MySQL latest, PHP latest. I followed all of the instructions for Windows servers on permissions, although I must say they were extremely lacking, and read like a unix guy wrote them.  (there is no execute flag in windows, you have to use IIS admin to set that directory as executeable) In any case, tables all setup ok... But when I ran the classic import, I get a permission error writing to the image directory, where it appears to be grabbing my additionally added graemlins. If I give IUSR full write access to the image dir and it's subs, the script completes just fine. Do I need to leave this write permission in place? Or is this just required during the import of the gfx files? ------ Then.... after that screen goes by (with or without errors) it starts on the users, gets two done, and stalls on the 3rd. No errors, just stops. Open to ideas here... Classic has been running here, for almost a decade now... (literally, it's so old, that it was shareware when I paid for it) But, it's running just fine, with no errors. I can access the stalled user, through the CP. Thanks!
_________________________
...usin' da classic UBB, since the beginning of time.  -- (and now trying to adapt to this 'upgrade')
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#182403 - 04/10/07 01:30 PM
Re: Image permission error on import?
[Re: Rick]
|
member
Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
|
It stops on the user, and says "Done" at the bottom of the browser. It's been sitting like that since my original post, and nothing has changed. I turned on display errors just now, with no change. (unless I need an IISReset to get it to reload the .ini? do I?) The user loads up just fine... and I don't see anything "odd"... they are a very old user, with no recent posts in the last 3 years. It will sound stupid... but he was a friend, that died, and we didn't have the heart to delete his account.
Andrew Chin
talons
2slow@rogers.com
http://
Write&22,24
does being a BUM count??
The Great White North
807
Member
Retirement! I already have a Camry!
noform
Slowpoke,<br />The Black Plagued 91 AWD
yes
1991
Eagle, Talon TSI AWD
http://
20
Andrew Bienhaus|^|00000010|^|04-10-2007
no
yes
yes
yes
yes
20020528|15|000045|000019|216.95.205.3
|no
24.101.203.181
0
0
0|0|0
0|^|MMM dd, yyyy|^|hh:mm a
_________________________
...usin' da classic UBB, since the beginning of time. -- (and now trying to adapt to this 'upgrade')
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#182404 - 04/10/07 01:34 PM
Re: Image permission error on import?
[Re: Andrew Bienhaus]
|
member
Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
|
and, to explain why I think the Classic data is stable... I mean that any rebuild I have ever run, has always run successfully. at this instant, I am running a complete rebuild & reindex of anything and everything, that classic 672 will let you reindex. (just in case) Will dump tables and try again after that. Oh, and can someone on your end, update the threads 7,1 install docs to reflect the comments so far? (IIS permissions errors, plus images dir permissions) Thanks!
_________________________
...usin' da classic UBB, since the beginning of time. -- (and now trying to adapt to this 'upgrade')
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#182419 - 04/10/07 03:50 PM
Re: Image permission error on import?
[Re: Andrew Bienhaus]
|
member
Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
|
Ok, here's the skinny...
Importing Adam Clay_dup16 - Adam Clay_dup16 (0) (Duplicate LoginName) (Duplicate DisplayName)
Importing Andrew Bienhaus_dup16 - Andrew Bienhaus_dup16 (1) (Duplicate LoginName) (Duplicate DisplayName)
Warning: mktime() expects parameter 4 to be long, string given in C:\Inetpub\ca.dsm.org\forums\importers\classic_import.php on line 2176
Importing Andrew Chin - Andrew Chin (2)
Warning: html::include(languages/english/generic.php) [function.html-include]: failed to open stream: No such file or directory in C:\Inetpub\ca.dsm.org\forums\libs\ubbthreads.inc.php on line 799
Warning: html::include() [function.include]: Failed opening 'languages/english/generic.php' for inclusion (include_path='.;C:\php5\pear') in C:\Inetpub\ca.dsm.org\forums\libs\ubbthreads.inc.php on line 799
Notice: Smarty error: unable to read resource: "not_right_bare.tpl" in C:\Inetpub\ca.dsm.org\forums\libs\smarty\Smarty.class.php on line 1088
That's after turning on the error messages. Note, my php is in c:\php and not the php5 it mentions here, but at the same time, I have never installed pear, nor was there mention of needing it? Thanks! Andrew
_________________________
...usin' da classic UBB, since the beginning of time. -- (and now trying to adapt to this 'upgrade')
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#182422 - 04/10/07 04:05 PM
Re: Image permission error on import?
[Re: Andrew Bienhaus]
|
Registered: 06/04/06
Posts: 7898
Loc: Aberdeen, WA
|
Ok, it's actually hiding the real error due to a bug in the importer. I just discovered this on an import I did today as well, and fixing up the importer now so it will show the real error. In the meantime, you can edit the libs/ubbthreads.inc.php file. Around line 804, you'll see a block of code that looks like this:
$smarty->assign("stylesheet",$stylesheet);
$smarty->assign("error",$error);
echo $smarty->fetch("not_right_bare.tpl");
Right after that, add this:
echo "THE ERROR IS:<br><br><b>$error</b><br><br>";
Once that's done then reload the page and you'll see the actual error in bold. A long way to go to get it, but once we get that, then we can see exactly what's going on.
Pear isn't actually needed, it's just referenced as it's in the current include path for PHP.
My first guess is that if you are running mysql 5, then it's currently running in strict mode and there is something about that user where it's trying to input a null value. If that ends up being the case, then you can quickly fix that by running the following SQL command:
SET GLOBAL SQL_MODE='';
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#182423 - 04/10/07 04:20 PM
Re: Image permission error on import?
[Re: Rick]
|
member
Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
|
Importing Adam Clay_dup17 - Adam Clay_dup17 (0) (Duplicate LoginName) (Duplicate DisplayName)
Importing Andrew Bienhaus_dup17 - Andrew Bienhaus_dup17 (1) (Duplicate LoginName) (Duplicate DisplayName)
Warning: mktime() expects parameter 4 to be long, string given in C:\Inetpub\ca.dsm.org\forums\importers\classic_import.php on line 2176
Importing Andrew Chin - Andrew Chin (2)
Warning: html::include(languages/english/generic.php) [function.html-include]: failed to open stream: No such file or directory in C:\Inetpub\ca.dsm.org\forums\libs\ubbthreads.inc.php on line 799
Warning: html::include() [function.include]: Failed opening 'languages/english/generic.php' for inclusion (include_path='.;C:\php5\pear') in C:\Inetpub\ca.dsm.org\forums\libs\ubbthreads.inc.php on line 799
Notice: Smarty error: unable to read resource: "not_right_bare.tpl" in C:\Inetpub\ca.dsm.org\forums\libs\smarty\Smarty.class.php on line 1088
THE ERROR IS:
Script: C:\Inetpub\ca.dsm.org\forums\importers\classic_import.php
Line#: 517
SQL Error: Incorrect integer value: '' for column 'USER_REGISTERED_ON' at row 1
SQL Error #: 1366
Query: insert into ubbt_USERS (USER_LOGIN_NAME,USER_DISPLAY_NAME,USER_PASSWORD,USER_MEMBERSHIP_LEVEL,USER_REGISTRATION_EMAIL,USER_REGISTRATION_IP,USER_IS_APPROVED,USER_REGISTERED_ON,USER_IS_BANNED,USER_IS_UNDERAGE) values ( 'Andrew Chin' , 'Andrew Chin' , 'taBVMAHxSptfc' , 'User' , '2slow@rogers.com' , '24.101.203.181' , 'yes' , '' , 0 , 0 ) is that what you expected? should I do the sql thing? (looks like it)
_________________________
...usin' da classic UBB, since the beginning of time. -- (and now trying to adapt to this 'upgrade')
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#182465 - 04/11/07 05:37 AM
Re: Image permission error on import?
[Re: Gizmo]
|
member
Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
|
Ahhhhhh I see. Will fix. Thanks. Question guys - how do I know, if the import completed successfully? Is there a flag set somewhere? Or can someone tell me what the last thing is that it does? I left it running, and the freakin' murphy's law of microsoft updates kicked in last night and rebooted it at 3am, and I have no idea if the import finished or not... Maybe an errorlog somewhere?
Edited by Andrew Bienhaus (04/11/07 05:42 AM)
_________________________
...usin' da classic UBB, since the beginning of time. -- (and now trying to adapt to this 'upgrade')
|
|
Top
|
|
|
|
|
|
|
|
|
|
Previous Topic
Index