XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 (2)


11
M_1008
Re: phpMyAdmin doesn´t export big tables

  • 2012/2/28 22:27

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


That functionality will be great in 2.5.4 if I finally get rid of 2.2.3.

I´ll try bigdump if I get errors importing, but I´m still stuck because I can´t export.

I´ve sent a mail to the hosting provider asking for help. I´ll post their answer if it can be helpfull to anyone.
Topic | Forum


12
M_1008
phpMyAdmin doesn´t export big tables

  • 2012/2/28 11:11

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


Hello,

I´m trying to import the data base from an obsolete web to a clean instalation (from XOOPS 2.2.3 to 2.5.4 and from CBB 3.04 to 4.06).

The problem is I can´t export the database with phpMyAdmin, if I try to download everything, all I get is a 0 bytes file.

Using a lot of patience, I´ve downloaded each of the 70 tables and everything goes well with the exception of prefix_bb_posts (82.7 MB), prefix_bb_posts_text (192.6 MB)
and prefix_priv_msgs (289.9 MB).

I searched a lot and if I understand well, the problem is a timeout that can be fixed changing $cfg['ExecTimeLimit'] to 0 at config.inc.php but I seem to have no access to this file with my provider.

Any idea?

On the other hand, the web was made back in 2006 by another person and I´ve found that I have all the tables repeated four times with 3 different prefixes, being duplicated even the one that´s in use but with last modification date from 2009.

Could I delete all this old tables without problem?


Thank you and excuse me about my poor english.
Topic | Forum


13
M_1008
Re: From deprecated to blank screen in CBB 3.08 with PHP 5.34

  • 2012/2/28 9:56

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


Thank you, Roby, but finally I got a CBB 4.06 in spanish that works perfect with 2.5.4.

Now I have another problem exporting the database, but I´ll post it in another thread because it´s not related.
Topic | Forum


14
M_1008
Re: From deprecated to blank screen in CBB 3.08 with PHP 5.34

  • 2012/2/23 20:44

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


I think i´ll continue with 3.08 as long as 4.2 doesn´t get to production and then I´ll start with this nightmare again. Hell.. I tought it was going to be easier.

I´ve enabled the debugging in preferences and this is all I get at the blank page:

( ! ) Fatal error: Call to undefined method MyTextSanitizerExtension::getInstance() in D:wampwwwxoopsFrameworkstextsanitizermodule.textsanitizer.php on line 215
Call Stack
#    Time    Memory    Function    Location
1    0.0040    1115344    {main}( )    ..viewtopic.php:0
2    0.3414    13076736    Post->showPost( )    ..viewtopic.php:317
3    0.3416    13077120    _XoopsPersistableObject->getVar( )    ..post.php:324
4    0.3417    13078360    MyTextSanitizer->displayTarea( )    ..object.persistable.php:80
5    0.3431    13100816    MyTextSanitizerExtended->xoopsCodeDecode( )    ..module.textsanitizer.php:529
6    0.3431    13107376    MyTextSanitizerExtended->xoopsCodeDecode_extended( )    ..module.textsanitizer.php:116
7    0.3431    13108704    MyTextSanitizerExtended->xoopsCodeDecode_media( )    ..module.textsanitizer.php:185
8    0.3432    13111752    MyTextSanitizerExtended->_loadExtension( )    ..module.textsanitizer.php:223
Nada Todo Errores (13) En desuso (1) Consultas (43) Bloques (5) Extra (2) Temporizadores(5)
Errores
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/user.php y línea 84
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /Frameworks/art/functions.ini.php y línea 90
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/include/functions.php y línea 377
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/include/functions.php y línea 391
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /Frameworks/art/object.php y línea 147
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /Frameworks/art/object.persistable.php y línea 259
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/topic.php y línea 180
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/topic.php y línea 387
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/post.php y línea 889
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/readtopic.php y línea 104
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/readtopic.php y línea 132
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/readtopic.php y línea 136
Desconocido: Assigning the return value of new by reference is deprecated en el archivo /modules/newbb/class/readtopic.php y línea 143


I appreciate your offer greatly, Roby73, but I don´t want to give you work without paying it as long as I can.

I´m considering trying to do this with Xoops 2.4.5 and see if I have more luck with it. If this doesn´t work, I guess I´ll have to pay someone to do it. Does this site have this type of service?
Topic | Forum


15
M_1008
Re: From deprecated to blank screen in CBB 3.08 with PHP 5.34

  • 2012/2/22 13:51

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


Thank you both.

Roby73, I can´t understand you fully. Are you telling me to send you the CBB folder by mail?

I´ve installed the 3.08 version because it is the newest one in the modules seccion of this site besides being from 2007. If there is a new production ready version, I´d prefer to use it, of course.

As soon as this works, the goal is importing the database from a CBB 3.04, it´s going to be possible? If it isn´t.. do I have any other option to keep all the data?
Topic | Forum


16
M_1008
Re: From deprecated to blank screen in CBB 3.08 with PHP 5.34

  • 2012/2/21 20:56

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


Ok, I did the change and the deprecated message dissapeared even with the error reporting on, but I´m still getting a blank page.

It seems like a progress, but at the same time, it doesn´t. With no error message I don´t know wich direction I can go :/

Topic | Forum


17
M_1008
Re: From deprecated to blank screen in CBB 3.08 with PHP 5.34

  • 2012/2/21 9:01

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


Thank you, I´ll try that as soon I get home ;)
Topic | Forum


18
M_1008
From deprecated to blank screen in CBB 3.08 with PHP 5.34

  • 2012/2/20 9:07

  • M_1008

  • Just popping in

  • Posts: 18

  • Since: 2012/2/20


Hi all,

I´ve installed a CBB 3.08 over a fresh installation of XOOPS 2.5.4 at my pc with Wamp 2.1 with PHP 5.3.4.

No problems with the install until I try to enter to the thread "Congratulations! The forum is working."

When I click it, it shows a blank screen with the following error.

"( ! ) Deprecated: Assigning the return value of new by reference is deprecated in D:\wamp\www\xoops\modules\newbb\viewtopic.php on line 582"

I´ve seen that it is frecuent and it´s commonly solved setting the error reporting off at php.ini or changing the value

error_reporting = E_ALL

to

error_reporting = E_ALL & ~E_DEPRECATED

With both of this solutions, error doesn´t show, but the screen is still blank.

Any ideas? I´m new to this world and I´m a little lost.

Thank you for your time and excuse my bad english.
Topic | Forum



TopTop
« 1 (2)



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

181 user(s) are online (122 user(s) are browsing Support Forums)

Members: 0

Guests: 181

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits