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

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

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

Rick

Post-a-holic

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

Looks like it's the max_allowed_packet variable. Maybe set that to like 2 Megs during the import in case you have any larger ones $;\)$

Top

#194998 - 08/23/07 01:15 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

Looks like it's the max_allowed_packet variable. Maybe set that to like 2 Megs during the import in case you have any larger ones $;\)$

How do I change that variable for the import only? Can I add it into the import script somewhere, or should I change it on the MySQL server temporarily?

Thanks,
Tim

Top

#194999 - 08/23/07 01:16 PM

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

Rick

Post-a-holic

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

It would need to go into the MySQL server config.

Top

#195023 - 08/23/07 05:03 PM

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

QSS Tim Offline

journeyman

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

I was able to get a successful import. I changed the max_allowed_packet to 16 meg in the my.ini. I also changed the table creation script to make the post_body, and post_default_body mediumtext to handle these whopping posts (it wasn't the first, and it won't be the last.) I chose to do it there as I've been dropping all the tables, recreating everything, and re-importing, and will be doing so at least one more time when I cut over from the classic to the threads.

But, it definitely looks like the worst part is over (wait... that's not true, the users coming forth with their "but this has changed" will probably be the worst part

)

I definitely appreciate the assistance!

Tim

Top

#195047 - 08/23/07 09:35 PM

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

Gizmo

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA

Originally Posted By: QSS Tim

(wait... that's not true, the users coming forth with their "but this has changed" will probably be the worst part

)

Natives don't like change, which is entertaining... Just explaine that the upgrade was nessessary due to more optimized coding and newer features, tends to calm them down $;\)$

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!

Top

#195051 - 08/23/07 09:53 PM

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

SD	Registered: 04/19/07 Posts: 4056 Loc: SoCal, USA

they are never satisfied, regardless of reason... i've been through too many 'we want it just like it was' threads...

human nature $\:\($

_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I

you, click this link as to why

Top

#195052 - 08/23/07 09:59 PM

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

ntdoc

Registered: 11/09/06
Posts: 3384

Amen... Been trying to get a user to switch over from Outlook 2002 client that only supports a 2GB PST file so that I can give him 2003 that supports a 20GB PST file.

He has nearly 30Gb of data on the mail server that I want to take off and place on a normal file server, but he doesn't like the look and feel of Outlook 2003 $\:p$