Code:
mysql> source D:\peqdb\load_bots.sql
Query OK, 0 rows affected (0.08 sec)
Query OK, 1 row affected (0.25 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.14 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected (0.16 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected (0.09 sec)
Query OK, 0 rows affected (0.09 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.08 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQ
L DATA in its declaration and binary logging is enabled (you *might* want to use
the less safe log_bin_trust_function_creators variable)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1305 (42000): FUNCTION eqs.GetMobType does not exist
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected (0.06 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.05 sec)
mysql>
I'm getting warnings and errors following the guide.
http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ
Quote:
A) Then type:
source peqdb_Rev859.sql;
and press Enter. //Few warnings; No Errors; used "peqdb_rev1496_2.sql" and not the mentioned older version.
B) Then type:
source load_player.sql;
and press Enter.//Errors
C) Then type:
source load_bots.sql;
and press Enter.//Not executed due to above failure.
|
Technical Details:
MySQL 5.1.36 (from
WAMP)
WindowsXP x64
Directory listing for SQL source files:
Code:
D:\peqdb>ls -la
total 141633
drwxrwxrwx 1 user group 0 May 25 00:18 .
drwxrwxrwx 1 user group 0 Jan 1 1980 ..
drwxrwxrwx 1 user group 0 May 24 23:42 .svn
-rw-rw-rw- 1 user group 564 Feb 25 15:38 drop_bots.sql
-rw-rw-rw- 1 user group 2297 Apr 18 19:13 drop_player.sql
-rw-rw-rw- 1 user group 2420 Apr 19 09:01 drop_system.sql
-rw-rw-rw- 1 user group 339 May 25 01:17 load_bots.sql
-rw-rw-rw- 1 user group 2918 May 25 01:15 load_player.sql
drwxrwxrwx 1 user group 0 May 24 23:31 peq_db
drwxrwxrwx 1 user group 0 May 25 01:33 peqdb_rev1496.sql
-rw-rw-rw- 1 user group 15986983 May 21 12:17 peqdb_rev1496.sql.gz
-rw-rw-rw- 1 user group 129031057 May 21 02:09 peqdb_rev1496_2.sql
drwxrwxrwx 1 user group 0 May 24 23:40 player_tables
-rw-rw-rw- 1 user group 1137 Aug 20 2009 readme.txt
drwxrwxrwx 1 user group 0 May 24 23:43 updates
D:\peqdb>cd player_tables
D:\peqdb\player_tables>ls -la
total 174
drwxrwxrwx 1 user group 0 May 24 23:40 .
drwxrwxrwx 1 user group 0 May 25 00:18 ..
drwxrwxrwx 1 user group 0 May 24 23:40 .svn
-rw-rw-rw- 1 user group 387 Jun 3 2009 Banned_IPs.sql
-rw-rw-rw- 1 user group 1861 Jun 3 2009 aa_timers.sql
-rw-rw-rw- 1 user group 2402 Feb 25 15:24 account.sql
-rw-rw-rw- 1 user group 281 Sep 21 2009 account_ip.sql
-rw-rw-rw- 1 user group 268 Sep 4 2009 account_rewards.sql
-rw-rw-rw- 1 user group 588 Jun 4 2009 adventure_details.sql
-rw-rw-rw- 1 user group 194 Jun 3 2009 adventure_members.sql
-rw-rw-rw- 1 user group 810 Jun 3 2009 adventure_stats.sql
-rw-rw-rw- 1 user group 748 May 25 01:12 botadventuring.sql
-rw-rw-rw- 1 user group 1106 Oct 24 2009 botbuffs.sql
-rw-rw-rw- 1 user group 1378 Feb 25 15:37 botgroups.sql
-rw-rw-rw- 1 user group 504 Dec 22 09:52 botguildmembers.sql
-rw-rw-rw- 1 user group 812 Apr 26 17:47 botinventory.sql
-rw-rw-rw- 1 user group 1676 Oct 24 2009 botpetstatepersists.sql
-rw-rw-rw- 1 user group 3622 Feb 26 22:01 bots.sql
-rw-rw-rw- 1 user group 629 Jun 3 2009 bugs.sql
-rw-rw-rw- 1 user group 319 Jun 3 2009 buyer.sql
-rw-rw-rw- 1 user group 186 Apr 18 19:11 char_recipe_list.sql
-rw-rw-rw- 1 user group 1370 Jun 3 2009 character_.sql
-rw-rw-rw- 1 user group 726 Jun 3 2009 character_activities.sql
-rw-rw-rw- 1 user group 2372 Jun 3 2009 character_backup.sql
-rw-rw-rw- 1 user group 569 Jun 3 2009 character_enabledtasks.sql
-rw-rw-rw- 1 user group 641 Jun 3 2009 character_tasks.sql
-rw-rw-rw- 1 user group 3289 Jun 3 2009 chatchannels.sql
-rw-rw-rw- 1 user group 26734 May 21 12:26 commands.sql
-rw-rw-rw- 1 user group 664 Jun 3 2009 completed_tasks.sql
-rw-rw-rw- 1 user group 282 May 21 12:26 db_version.sql
-rw-rw-rw- 1 user group 2119 Jun 3 2009 eventlog.sql
-rw-rw-rw- 1 user group 1835 Jun 3 2009 faction_values.sql
-rw-rw-rw- 1 user group 260 Jun 15 2009 friends.sql
-rw-rw-rw- 1 user group 237 Jun 3 2009 gm_ips.sql
-rw-rw-rw- 1 user group 405 Jun 3 2009 group_id.sql
-rw-rw-rw- 1 user group 496 Oct 18 2009 group_leaders.sql
-rw-rw-rw- 1 user group 530 Apr 18 19:11 guild_bank.sql
-rw-rw-rw- 1 user group 2135 May 21 12:26 guild_members.sql
-rw-rw-rw- 1 user group 2286 Jun 3 2009 guild_ranks.sql
-rw-rw-rw- 1 user group 1856 Jun 3 2009 guild_relations.sql
-rw-rw-rw- 1 user group 2083 May 21 12:27 guilds.sql
-rw-rw-rw- 1 user group 537 Jun 3 2009 hackers.sql
-rw-rw-rw- 1 user group 397 Jun 3 2009 instance_lockout.sql
-rw-rw-rw- 1 user group 209 Jun 3 2009 instance_lockout_player.sql
-rw-rw-rw- 1 user group 2239 Jun 3 2009 inventory.sql
-rw-rw-rw- 1 user group 486 Jun 3 2009 keyring.sql
-rw-rw-rw- 1 user group 1779 Jun 3 2009 launcher.sql
-rw-rw-rw- 1 user group 1825 Jun 3 2009 launcher_zones.sql
-rw-rw-rw- 1 user group 396 Jun 3 2009 mail.sql
-rw-rw-rw- 1 user group 570 Jun 3 2009 merchantlist_temp.sql
-rw-rw-rw- 1 user group 10008 Jun 16 2009 name_filter.sql
-rw-rw-rw- 1 user group 2259 Jun 3 2009 object_contents.sql
-rw-rw-rw- 1 user group 2374 Jun 3 2009 petitions.sql
-rw-rw-rw- 1 user group 2367 Jun 3 2009 player_corpses.sql
-rw-rw-rw- 1 user group 2258 Jun 3 2009 player_corpses_backup.sql
-rw-rw-rw- 1 user group 213 Feb 25 15:26 player_titlesets.sql
-rw-rw-rw- 1 user group 2100 Jun 3 2009 quest_globals.sql
-rw-rw-rw- 1 user group 555 Jun 3 2009 raid_details.sql
-rw-rw-rw- 1 user group 761 Jun 3 2009 raid_members.sql
-rw-rw-rw- 1 user group 243 Aug 27 2009 reports.sql
-rw-rw-rw- 1 user group 528 Jun 3 2009 respawn_times.sql
-rw-rw-rw- 1 user group 467 Jun 3 2009 rule_sets.sql
-rw-rw-rw- 1 user group 28521 Apr 22 10:13 rule_values.sql
-rw-rw-rw- 1 user group 2137 Jun 3 2009 sharedbank.sql
-rw-rw-rw- 1 user group 308 Feb 25 15:26 spell_globals.sql
-rw-rw-rw- 1 user group 1878 Jun 3 2009 timers.sql
-rw-rw-rw- 1 user group 424 Jun 3 2009 trader.sql
-rw-rw-rw- 1 user group 325 Jun 3 2009 trader_audit.sql
-rw-rw-rw- 1 user group 2869 Jun 3 2009 variables.sql
-rw-rw-rw- 1 user group 1746 Jun 3 2009 zone_flags.sql
D:\peqdb\player_tables>
I'm very limited in my knowledge with SQL. I've worked with it, but only on a very basic level for storing simple values via php scripting and pre-built databases using phpMyAdmin, so I really have no clue what went wrong here.
And yes, I did search for this error I had, but no real use.
I manually tried to add each item from player_tables folder into a test DB in MySQL using phpMyAdmin, and this was the results and some tweaking around with no success.. mind you I have minimal clue what I'm actually doing (in end), but I can kinda follow along with the code.
botadventuring.sql had an error, so that may be usefully related.
I can't think of any other useful or relevant information on this issue.
Other info: English isn't my first language, so I hope I'm being at lease decently understandable.