 |
 |
 |
 |
Registered: 07/07/05
Posts: 62
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#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