Import fails regarding opening generic.php - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Importer Assistance » Import fails regarding opening generic.php

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	51
Gizmo	24
DennyP	24
Dunny	15
SteveS	14
AllenAyres	12
dbremer	10
SD	10
drkknght00	9
doug	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Page 1 of 2

Topic Options

#194938 - 08/22/07 04:57 PM

Import fails regarding opening generic.php

QSS Tim Offline

journeyman

Registered: 10/20/04
Posts: 90
Loc: Oroville, CA

Here is the screen when I checked on it and found out it failed:

Code:

Importing threads from UBB.classic� Forum number 115, 100 of 156 total to be imported.

Importing "Relieving encumbrances" (2 replies)
Importing "Prod Scattergram Report Down" (2 replies)
Importing "GL Report Writer - Unable to Sort on SubObj" (5 replies)
Importing "Burdens on Cancelled PAY warrants not on SAP" (3 replies)

Warning: html::include(languages/english/generic.php) [function.include]: failed to open stream: No such file or directory in C:\Inetpub\qsswww\forums\libs\ubbthreads.inc.php on line 892

Warning: html::include() [function.include]: Failed opening 'languages/english/generic.php' for inclusion (include_path='.;C:\php5\pear') in C:\Inetpub\qsswww\forums\libs\ubbthreads.inc.php on line 892

Notice: Smarty error: unable to read resource: "not_right_bare.tpl" in C:\Inetpub\qsswww\forums\libs\smarty\Smarty.class.php on line 1087

That path in there (c:\php5\pear) does not exist. I also have no idea where it came from, as that path has never existed on this machine as php has always been installed in c:\php.

_________________________
UBB Since November 07, 2000.

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#194987 - 08/23/07 11:16 AM

Re: Import fails regarding opening generic.php [Re: QSS Tim]

QSS Tim Offline

journeyman

Registered: 10/20/04
Posts: 90
Loc: Oroville, CA

FWIW... I rebuilt the Classic forums last night, and am trying the import again after dropping/recreating all the tables. Fingers crossed

Top

#194989 - 08/23/07 12:00 PM

Re: Import fails regarding opening generic.php [Re: QSS Tim]

QSS Tim Offline

journeyman

Registered: 10/20/04
Posts: 90
Loc: Oroville, CA

No joy... same exact results:

Code:

Importing threads from UBB.classic� Forum number 115, 100 of 156 total to be imported.

Importing "Relieving encumbrances" (2 replies)
Importing "Prod Scattergram Report Down" (2 replies)
Importing "GL Report Writer - Unable to Sort on SubObj" (5 replies)
Importing "Burdens on Cancelled PAY warrants not on SAP" (3 replies)

Warning: html::include(languages/english/generic.php) [function.include]: failed to open stream: No such file or directory in C:\Inetpub\qsswww\forums\libs\ubbthreads.inc.php on line 892

Warning: html::include() [function.include]: Failed opening 'languages/english/generic.php' for inclusion (include_path='.;C:\php5\pear') in C:\Inetpub\qsswww\forums\libs\ubbthreads.inc.php on line 892

Notice: Smarty error: unable to read resource: "not_right_bare.tpl" in C:\Inetpub\qsswww\forums\libs\smarty\Smarty.class.php on line 1087

Any help/insight/suggestions greatly appreciated. I still can't find out where that php5 path is coming from either.

Thanks,
Tim

Top

#194990 - 08/23/07 12:02 PM

Re: Import fails regarding opening generic.php [Re: QSS Tim]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA

The php5 path is normal, that's just comes from the standard path setting where it will search by default. The problem seems to be that it can't locate the language files. Does the forum itself seem to be operation after the installation was done?

Top

#194992 - 08/23/07 12:21 PM

Re: Import fails regarding opening generic.php [Re: Rick]

QSS Tim Offline

journeyman

Registered: 10/20/04
Posts: 90
Loc: Oroville, CA

The forum works fine after the import fails. I made some code changes for extended error reporting that I found here after doing some changes to what I was searching on (http://www.ubbcentral.com/forums/ubbthreads.php/ubb/showflat/Number/184213/fpart/2).

Here is the error with the more detailed error information after making those changes:

Importing threads from UBB.classic� Forum number 115, 100 of 156 total to be imported.

Importing "Relieving encumbrances" (2 replies)
Importing "Prod Scattergram Report Down" (2 replies)
Importing "GL Report Writer - Unable to Sort on SubObj" (5 replies)
Importing "Burdens on Cancelled PAY warrants not on SAP" (3 replies)
Script: C:\Inetpub\qsswww\forums\importers\classic_import.php
Line#: 1280
SQL Error: MySQL server has gone away
Please verify that your MySQL server is running
SQL Error #: 2006
Query: INSERT INTO ubbt_POSTS (POST_PARENT_ID,TOPIC_ID,POST_IS_TOPIC,POST_POSTED_TIME,POST_POSTER_IP,POST_SUBJECT,POST_BODY,POST_DEFAULT_BODY, POST_ICON,POST_IS_MEMBER_POST,USER_ID,POST_ADD_SIGNATURE) VALUES ( Cut out for bandwidth conservation, but it's HUGE )

The post is HUGE with tons of text. Am I hitting some sort of limit or something? I see the referenced thread mentions a similar problem. I'm not sure though what other edits I really should be doing to handle the larger posts (assuming that really is the issue.)

_________________________
UBB Since November 07, 2000.

Top

#194993 - 08/23/07 12:38 PM

Re: Import fails regarding opening generic.php [Re: QSS Tim]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA

Hmm, this line is definitely not good:

"SQL Error: MySQL server has gone away"

That basically means your mysql server has died or stopped responding for that query. Is this your own server or are you on a hosted server?

Top

#194994 - 08/23/07 12:47 PM

Re: Import fails regarding opening generic.php [Re: Rick]

QSS Tim Offline

journeyman

Registered: 10/20/04
Posts: 90
Loc: Oroville, CA

Originally Posted By: Rick

It's our own server, and it had not actually gone away. It is used for a variety of other functions and none experienced any issues. It looks like the query is about 1,049,310 characters long. I'd think it's most likely a case that it has stopped responding.

Tim

Top

#194995 - 08/23/07 12:52 PM

Re: Import fails regarding opening generic.php [Re: QSS Tim]

QSS Tim Offline

journeyman

Registered: 10/20/04
Posts: 90
Loc: Oroville, CA

Is this a case where the "alter table ubbt_POSTS change POST_BODY mediumtext, change POST_DEFAULT_BODY mediumtext" is applicable. And if so, do I just run this query after building the tables, prior to importing?

_________________________
UBB Since November 07, 2000.

Top

#194996 - 08/23/07 12:54 PM

Re: Import fails regarding opening generic.php [Re: QSS Tim]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA

Ok, I believe the default max query size MySQL allows is 1 meg, so you're probably hitting that ceiling. Let me see if I can figure out what variable needs to be changed.

Top