0 Members and 1 Guest are viewing this topic.

I Got an error while trying to install
« on: September 27, 2013, 08:10:21 AM »
Server: IIS 8.5
Php: 5.3.27
osdate: 2.6
MySQLi 5.6.14

My error

Code: [Select]
Writing installation parameters to config.php file... Done
Creating new tables...
    Creating table : osdate_admin ... done
    Creating table : osdate_admin_permissions ... done
    Creating table : osdate_adminemails ... done
    Creating table : osdate_aff_referals ... done
    Creating table : osdate_affiliates ... done
    Creating table : osdate_articles ... done
    Creating table : osdate_banners ... done
    Creating table : osdate_blog_comments ... done
    Creating table : osdate_blog_preferences ... done
    Creating table : osdate_blog_story ... done
    Creating table : osdate_blog_vote ... done
    Creating table : osdate_buddy_ban_list ... done
    Creating table : osdate_calendars ... done
    Creating table : osdate_calendarevents ... done
    Creating table : osdate_calendarwatchevents ... done
    Creating table : osdate_cities ... done
    Creating table : osdate_counties ... done
    Creating table : osdate_countries ... done
    Creating table : osdate_featured_profiles ... done
    Creating table : osdate_glblsettings ... done
    Creating table : osdate_imported_users ... done
    Creating table : osdate_import_questions_xref ... done
    Creating table : osdate_instant_message ... done
    Creating table : osdate_languages ... done
    Creating table : osdate_letters ... done
    Creating table : osdate_log ... done
    Creating table : osdate_mailbox ... done
    Creating table : osdate_membership ... done
    Creating table : osdate_news ... done
    Creating table : osdate_onlineusers ... done
    Creating table : osdate_pages ... done
    Creating table : osdate_payment_config ... done
    Creating table : osdate_payment_modules ... done
    Creating table : osdate_plugin ... done
    Creating table : osdate_plugin_access ... done
    Creating table : osdate_plugin_config ... done
    Creating table : osdate_plugin_tables ... done
    Creating table : osdate_pollips ... done
    Creating table : osdate_polloptions ... done
    Creating table : osdate_polls ... done
    Creating table : osdate_poll_answer ... done
    Creating table : osdate_poll_option ... done
    Creating table : osdate_poll_question ... done
    Creating table : osdate_promo ... done
    Creating table : osdate_promo_used ... done
    Creating table : osdate_questionoptions ... done
    Creating table : osdate_questions ... done
    Creating table : osdate_ratings ... done
    Creating table : osdate_sections ... done
    Creating table : osdate_shoutbox ... done
    Creating table : osdate_states ... done
    Creating table : osdate_stories ... done
    Creating table : osdate_transactions ... done
    Creating table : osdate_user ... done
    Creating table : osdate_user_watched_profiles ... done
    Creating table : osdate_user_actions ... done
    Creating table : osdate_useralbums ... done
    Creating table : osdate_user_choices ... done
    Creating table : osdate_userpreference ... done
    Creating table : osdate_userrating ... done
    Creating table : osdate_usersearches ... done
    Creating table : osdate_usersnaps ... done
    Creating table : osdate_usertemplates ... done
    Creating table : osdate_uservideos ... done
    Creating table : osdate_views_winks ... done
    Creating table : osdate_zips ... done
    Creating table : osdate_mails ... done
Table creation is completed
Loading system control data to database... completed.
Loading sample data to database... Failed
Inserting sample data into tables in the database failed. It could be because of incompatible type or insufficient space. If any tables are created, drop those tables. Please check and restart installation process
not sure how to fix ????

Re: I Got an error while trying to install
« Reply #1 on: September 27, 2013, 10:04:34 AM »
If I try just adding(sample_data.sql) through phpmyadmin to database I get
Code: [Select]
SQL query:

##
## Dumping data for table `[prefix]_adminemails`
##
INSERT INTO `[prefix]_adminemails` ( `id` , `email` )
VALUES ( 5, 'info@domain.com' ) ;

MySQL said: Documentation
#1146 - Table 'howmansworld.[prefix]_adminemails' doesn't exist
funny thing is it does exist in table osdate_adminemails
php error log says
[27-Sep-2013 03:50:11] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 35 bytes) in ?:\???????\???????\??????\?????????\osdate\init.php on line 335
[27-Sep-2013 04:17:17] PHP Fatal error:  Allowed memory size of 402653184 bytes exhausted (tried to allocate 16 bytes) in ?:\???????\???????\??????\?????????\osdate\init.php on line 334
and i have played with the memory. right now in the php.ini it is memory limit 2048M
Sill no go

*

CBG

  • *****
  • 960
    • osDate Forum
  • osDate Version: osDateEvo v1.3
Re: I Got an error while trying to install
« Reply #2 on: September 27, 2013, 04:32:47 PM »
You need to edit the sample sql change

[prefix] to osdate

As it looking for [prefix]_adminemails
You have osdate_adminemails
Regards,
CBG (Garry)
PHP: 5.x and 7.x | MySQL: 10.1.31-MariaDB-cll-lve

Re: I Got an error while trying to install
« Reply #3 on: September 27, 2013, 06:52:59 PM »
You need to edit the sample sql change

[prefix] to osdate

As it looking for [prefix]_adminemails
You have osdate_adminemails

Would that mean I would have to change all occurrences of [prefix] to osdate
Is that not the install script's job to incert osdate. (wish I knew how to fix this my self) But I am going to try what you said and replace [prefix] with osdate

Thank you for your quick response

Re: I Got an error while trying to install
« Reply #4 on: September 27, 2013, 07:13:55 PM »
still No go I tried two ways again
1. changed all [prefix] to osdate in the sample_data.sql then reran script and got same as before
Code: [Select]
Table creation is completed
Loading system control data to database... completed.
Loading sample data to database... Failed
Inserting sample data into tables in the database failed. It could be because of incompatible type or insufficient space. If any tables are created, drop those tables. Please check and restart installation process
2. imported with phpmyadmin with all the [prefix] to osdate in the sample_data.sql changed
Code: [Select]
SQL query:

##
## Dumping data for table `osdate_adminemails`
##
INSERT INTO `osdate_adminemails` ( `id` , `email` )
VALUES ( 5, 'info@domain.com' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '5' for key 'PRIMARY'

*

CBG

  • *****
  • 960
    • osDate Forum
  • osDate Version: osDateEvo v1.3
Re: I Got an error while trying to install
« Reply #5 on: September 28, 2013, 02:58:32 PM »
Did you delete everything in the database before re-install.
As you need to do that, or you may get an error, like you have.
Regards,
CBG (Garry)
PHP: 5.x and 7.x | MySQL: 10.1.31-MariaDB-cll-lve

Re: I Got an error while trying to install
« Reply #6 on: September 28, 2013, 05:53:46 PM »
Did you delete everything in the database before re-install.
As you need to do that, or you may get an error, like you have.

Yea I delete everything that has osdate_ on the front, as there is other tables table in this data base.

Re: I Got an error while trying to install
« Reply #7 on: February 09, 2014, 12:55:48 PM »
I have the same error. has anyone how it fixed?


*

Pharg

  • *****
  • 3,191
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: I Got an error while trying to install
« Reply #8 on: September 14, 2015, 11:13:10 PM »
Hi Achilles,

Try downloading osDate v2.6.5 and don't install on anything higher than PHP 5.4
Regards,
Pharg ( Phill )

Don't Personal Message me unless it's about a sensitive matter!!

REMEMBER TO ALWAYS BACKUP BEFORE MAKING ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.2 | MySQL: 5.5.35

Re: I Got an error while trying to install
« Reply #9 on: October 12, 2016, 03:59:33 AM »
I am having the same error.
Inserting sample data into tables in the database failed. It could be because of incompatible type or insufficient space. If any tables are created, drop those tables. Please check and restart installation process.

Php 5.4
Mysql version: 5.6.30

I have an other domain with php 5.4 and mysql 5.5 and works perfectly.
I backed up the app and the database from the working domain to this domain.

i am able to login. but cannot register any user.
PHP Deprecated:  mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/senthilkumar5454/public_html/libs/adodb/drivers/adodb-mysql.inc.php on line 480

I cannot edit any user as well.

Please help.

Re: I Got an error while trying to install
« Reply #10 on: October 12, 2016, 04:01:05 AM »
Hosting provider is godaddy.

I called godaddy tech support, requested them to downgrade my sql version. They say it is not possible.

*

Pharg

  • *****
  • 3,191
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: I Got an error while trying to install
« Reply #11 on: October 12, 2016, 04:17:34 AM »
Hi sathya,

What version osDate did you install?
Regards,
Pharg ( Phill )

Don't Personal Message me unless it's about a sensitive matter!!

REMEMBER TO ALWAYS BACKUP BEFORE MAKING ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.2 | MySQL: 5.5.35

Re: I Got an error while trying to install
« Reply #12 on: October 13, 2016, 05:50:22 AM »
osDateEvoV1.0

*

Pharg

  • *****
  • 3,191
    • OsDateFourm
  • osDate Version: osDateEvo v1.3
Re: I Got an error while trying to install
« Reply #13 on: October 13, 2016, 06:22:41 AM »
Hi sathya,

It should be fine in PHP 5.4 with the install.

Private message me your website details and access details please?
FTP and Control panel username and passwords.
Regards,
Pharg ( Phill )

Don't Personal Message me unless it's about a sensitive matter!!

REMEMBER TO ALWAYS BACKUP BEFORE MAKING ANY CHANGES!!

osDateEvo v1.3 | PHP: 5.3.42 & PHP: 7.2 | MySQL: 5.5.35

Re: I Got an error while trying to install
« Reply #14 on: October 13, 2016, 07:17:51 AM »
I have sent you Private message with access details.

Thanks in advance for your support