NEED HELP WITH BIGIN(19) categories_id

[don01234]

I have v.2.3.1 and I am trying to build a store with over 80,000 items. I was thinking about going with easypopluate but it seems not that stable yet so I am in progress of putting data straight to mysql.

My problem is with categories_id in tables products_to_categories, categories, categories_description. My seller has INT (19) as categories_id so I changed categories_id field in tables listed above to BIGINT (19) and was able to insert the data to tables. Now when I insert categories_id to products_to_catgories table and categories_id to categories_description table my site still works. However, when I insert the same data to categories table to and refresh my site all I get is following:

 

 

 

( ! ) Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\catalog\includes\functions\database.php on line 44

Call Stack

# Time Memory Function Location

1 0.0020 481104 {main}( ) ..\index.php:0

2 0.1430 2246096 require( 'C:\wamp\www\catalog\includes\template_top.php' ) ..\index.php:35

3 0.1430 2246096 oscTemplate->buildBlocks( ) ..\template_top.php:13

4 0.1456 2306576 bm_categories->execute( ) ..\osc_template.php:93

5 0.1456 2306608 bm_categories->getData( ) ..\bm_categories.php:159

6 0.1464 2312232 bm_categories->tep_show_category( ) ..\bm_categories.php:143

7 0.5057 2312456 bm_categories->tep_show_category( ) ..\bm_categories.php:77

8 16.0595 2312656 bm_categories->tep_show_category( ) ..\bm_categories.php:77

9 16.0599 2312808 tep_count_products_in_category( ) ..\bm_categories.php:68

10 29.4055 2316008 tep_count_products_in_category( ) ..\general.php:410

11 29.9829 2321376 tep_count_products_in_category( ) ..\general.php:410

12 29.9829 2321624 tep_db_query( ) ..\general.php:402

 

 

 

 

Please help…