Updated today and have naked char's :-)

[Xelaan]

So I updated the DB and Source today to peqdb version 610 and the code to r666. Everything compiled fine and had no problems. I sourced the various sql files from the utils directory.

600_group_leadership.sql
612_instance_changes.sql
615_adventure_assassination.sql
619_Adventure_Recruiter_Flavor.sql
621_LDoNTraps.sql
633_ucs.sql
634_TrapTemplateDefaultValue.sql
643_BotsTable.sql
646_archery_penalty_rule.sql
665_heroic_resists.sql

I also added in the SQL updates from the new db version.

Rev553.sql
Rev590.sql
Rev59.sql
Rev610.sql

The problem is whenever I logon with either Titanium or SoF all of my characters are naked. When I look in database all of the items appear to be in palce still. I did backup the tables before I loaded the changes. Here are the errors being dropped into the log when I log a character on to the server.

21947 [06.15. - 14:41:07] Starting Log: logs/eqemu_error_zone.log
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106809 in inventory slot 1
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 4504 in inventory slot 2
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106810 in inventory slot 3
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 7945 in inventory slot 4
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106811 in inventory slot 5
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 28902 in inventory slot 6
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20245 in inventory slot 7
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 22816 in inventory slot 8
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20244 in inventory slot 9
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 104785 in inventory slot 10
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106869 in inventory slot 11
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25201 in inventory slot 12
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106858 in inventory slot 13
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106863 in inventory slot 14
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106719 in inventory slot 15
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 28884 in inventory slot 16
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 104791 in inventory slot 17
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20247 in inventory slot 18
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20246 in inventory slot 19
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 2406 in inventory slot 20
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 66167 in inventory slot 21
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17353 in inventory slot 22
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 23
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 24
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 25
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 66240 in inventory slot 26
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 27
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 28
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 29
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 251
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10033 in inventory slot 252
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10048 in inventory slot 253
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10048 in inventory slot 254
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10036 in inventory slot 255
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 256
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10001 in inventory slot 257
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10053 in inventory slot 258
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 18866 in inventory slot 261
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 18811 in inventory slot 262
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 263
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 5410 in inventory slot 264
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10037 in inventory slot 265
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 21864 in inventory slot 266
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10049 in inventory slot 267
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24930 in inventory slot 268
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10049 in inventory slot 269
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25076 in inventory slot 270
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10035 in inventory slot 271
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 272
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 4564 in inventory slot 273
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 274
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 22503 in inventory slot 275
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10034 in inventory slot 276
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 277
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10049 in inventory slot 278
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 5154 in inventory slot 279
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10048 in inventory slot 280
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24949 in inventory slot 281
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 282
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1858 in inventory slot 283
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 13007 in inventory slot 284
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24932 in inventory slot 285
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 2474 in inventory slot 286
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1627 in inventory slot 287
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1606 in inventory slot 288
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 6478 in inventory slot 289
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 7276 in inventory slot 290
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 22819 in inventory slot 301
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 2414 in inventory slot 302
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 30050 in inventory slot 303
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 13045 in inventory slot 304
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10030 in inventory slot 305
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 14905 in inventory slot 306
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11625 in inventory slot 307
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24727 in inventory slot 308
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11582 in inventory slot 309
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 28521 in inventory slot 310
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1560 in inventory slot 311
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 29781 in inventory slot 321
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10032 in inventory slot 322
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 37539 in inventory slot 323
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 62271 in inventory slot 325
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106818 in inventory slot 327
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 106859 in inventory slot 328
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 5529 in inventory slot 329
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 30516 in inventory slot 2000
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10025 in inventory slot 2001
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 22122 in inventory slot 2002
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2003
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 13990 in inventory slot 2005
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2007
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2008
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17703 in inventory slot 2009
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2010
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2011
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2012
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2013
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2014
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2015
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24928 in inventory slot 2061
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24953 in inventory slot 2062
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24948 in inventory slot 2063
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24952 in inventory slot 2064
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 21779 in inventory slot 2065
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25820 in inventory slot 2111
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24939 in inventory slot 2112
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11629 in inventory slot 2113
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24940 in inventory slot 2114
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10219 in inventory slot 2115
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 19071 in inventory slot 2116
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 6401 in inventory slot 2117
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 62649 in inventory slot 2118
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 27989 in inventory slot 2119
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20243 in inventory slot 2120
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11643 in inventory slot 2122
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 51624 in inventory slot 2123
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1558 in inventory slot 2124
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1556 in inventory slot 2125
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10051 in inventory slot 2126
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10029 in inventory slot 2131
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10036 in inventory slot 2132
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10022 in inventory slot 2133
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10033 in inventory slot 2134
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10032 in inventory slot 2135
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10225 in inventory slot 2136
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10034 in inventory slot 2137
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10027 in inventory slot 2140
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 2324 in inventory slot 2141
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 6335 in inventory slot 2142
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 28022 in inventory slot 2143
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 27167 in inventory slot 2144
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 9979 in inventory slot 2145
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20263 in inventory slot 2146
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25843 in inventory slot 2147
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 15843 in inventory slot 2149
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25817 in inventory slot 2151
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25841 in inventory slot 2152
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25842 in inventory slot 2153
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25807 in inventory slot 2154
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25836 in inventory slot 2155
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25805 in inventory slot 2156
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25839 in inventory slot 2157
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25826 in inventory slot 2158
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25814 in inventory slot 2159
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25815 in inventory slot 2160
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1365 in inventory slot 2161
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 5157 in inventory slot 2162
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1401 in inventory slot 2163
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24724 in inventory slot 2164
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10174 in inventory slot 2165
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20248 in inventory slot 2166
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10109 in inventory slot 2167
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24752 in inventory slot 2168
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25222 in inventory slot 2169
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 2468 in inventory slot 2170
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10127 in inventory slot 2171
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1531 in inventory slot 2172
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 68273 in inventory slot 2173
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11663 in inventory slot 2174
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 6401 in inventory slot 2175
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11622 in inventory slot 2176
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1401 in inventory slot 2177
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11621 in inventory slot 2178
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24938 in inventory slot 2179
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1412 in inventory slot 2180
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10011 in inventory slot 2181
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 14509 in inventory slot 2182
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10028 in inventory slot 2183
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10035 in inventory slot 2184
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 22503 in inventory slot 2185
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10053 in inventory slot 2186
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10012 in inventory slot 2187
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10031 in inventory slot 2188
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10019 in inventory slot 2189
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 10037 in inventory slot 2190
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2500
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 17403 in inventory slot 2501
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 11666 in inventory slot 2531
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 15864 in inventory slot 2532
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 27276 in inventory slot 2533
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 27996 in inventory slot 2534
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25982 in inventory slot 2535
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24645 in inventory slot 2536
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 27987 in inventory slot 2537
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 5154 in inventory slot 2538
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 1117 in inventory slot 2539
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24585 in inventory slot 2541
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 22995 in inventory slot 2542
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 26992 in inventory slot 2543
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 24754 in inventory slot 2544
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 20506 in inventory slot 2545
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 9239 in inventory slot 2546
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25220 in inventory slot 2547
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 26861 in inventory slot 2548
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 25198 in inventory slot 2549
21947 [06.15. - 14:41:07] Warning: charid 144 has an invalid item_id 28823 in inventory slot 2550

If anayone has any suggestions I would love to hear them. I am hoping I don't have to rebuild all of the inventories. :-( (couple hundred characters are created on the server, shudder)

[nosfentora]

So I updated the DB and Source today to peqdb version 610 and the code to r666. Everything compiled fine and had no problems. I sourced the various sql files from the utils directory.

600_group_leadership.sql
612_instance_changes.sql
615_adventure_assassination.sql
619_Adventure_Recruiter_Flavor.sql
621_LDoNTraps.sql
633_ucs.sql
634_TrapTemplateDefaultValue.sql
643_BotsTable.sql
646_archery_penalty_rule.sql
665_heroic_resists.sql

I also added in the SQL updates from the new db version.

Rev553.sql
Rev590.sql
Rev59.sql
Rev610.sql

The problem is whenever I logon with either Titanium or SoF all of my characters are naked. When I look in database all of the items appear to be in palce still. I did backup the tables before I loaded the changes. Here are the errors being dropped into the log when I log a character on to the server.

If anayone has any suggestions I would love to hear them. I am hoping I don't have to rebuild all of the inventories. :-( (couple hundred characters are created on the server, shudder)

It sounds like your items table is empty or not up to date.

Why did you update to 610 and then "back-patch" 590, 600?
What rev did you start with?

I'm hoping you didn't do these in the order you listed.

also Rev59.sql shouldn't have even been an option.

Did you use the full peqdb file? (ie peqdb_1129rev628.sql?)

Do you have customizations to the items db or spawns? if not, the easiest fix would be
source drop_system.sql
source peqdb_1129Rev628.sql

that will bring you to 628 (encompasses also up to 633_ucs.sql)

you can then source in anything above the 633_ucs.sql.

[Xelaan]

Rev59.sql was a typo from when I pasted out of the dir listing. Sorry about that. I was not sourced.

The items table is populated and has all of the data. I dod not source the entire database, I have some customizations, but I can add those back in easy enough if I have to, I am trying to avoid that though. If that is my only option then I will pull the trigger. Not sure why the sourcing of the sql's did not work if I have to reload the entire DB.

I was on the 553 version of the DB prior to my upgrade today. So I sourced everything after 553.

[trevius]

Your original custom DB should work just fine as long as you source in the SQL from the /utils/sql/svn directory in the EQEmu source code trunk. The most important one is the one for Heroic Resists. Make sure that you ran that SQL AFTER you did all of the PEQ db update stuff, or you will be missing those new fields, which will cause items to fail to load, which is what is causing your problem. Your inventory table should be fine.

[Xelaan]

I assumed after reading these that something got corrupted during my upgrade. So I decided to start again. I ran drop_system.sql and reloaded the database. I sourced in all the updates that were later than the 628 version of the db.

I restarted my world and logged back in and I am still naked. :-(

I sourced in the SQL updates and the SQL updates from the EQEmu.

[trevius]

Check your items table and be sure that you have fields near the far right end of the table that are named; herioc_pr, heroic_dr, heroic_fr, heroic_cr, and heroic_svcorrup. If you don't have those fields, then the way you are running the SQL updates is being done in the wrong order. You MUST run the heroic resists sql update from the EQEmu folder after you are done with everything else. Otherwise, you are overwritting the update by resourcing the PEQ stuff. This is because redoing the database from scratch will remove all tables and then re-add them, which removes the new columns you just added.

[gaeorn]

I am having the same problem and I have confirmed the heroic resists fields are in the items table. I am on peqdb 669 and eqemu rev 670.

Since I run 64bit, I'm building 32bit version to make sure it doesn't have to do with my arch. I'll post again when I've tested that.

[gaeorn]

The 32bit compile does not have the same problem for me. I'll look into the changes to see where the problem for 64bit is.

[cavedude]

Make sure you do a make clean, your library HAS to be rebuilt in order to accept the changes to the items table.

[gaeorn]

Hrm. I doubt I did a make clean. Are the dependencies incorrect so it won't rebuild the library?

I'm doing a make clean and rebuilding to test.

[gaeorn]

Yup, make clean before building took care of it. Stupid dependencies... (mutter grumble).

[Xelaan]

make clean fixed my inventory problem as well. Thank you! One more thing I have learned. :-)

However, I have a new problem. I cannot cast any spells. I get an Arguement out of range when I try to cast a spell. It gives me that error if I try to cast a spell from my spell gem, or if I try to use the #castspell command as well.

Any thoughts for this one?

[cavedude]

I had the same problem, try:

update spells_new set teleport_zone='' where teleport_zone is null;
update spells_new set you_cast ='' where you_cast is null;
update spells_new set other_casts ='' where other_casts is null;
update spells_new set cast_on_you ='' where cast_on_you is null;
update spells_new set cast_on_other ='' where cast_on_other is null;
update spells_new set spell_fades ='' where spell_fades is null;

Or, just grab the newest PEQ database and use that spells_new table.

[Xelaan]

I tried both solutions, I tried entering the SQL to update the table, problem still existed.

I then did another drop_system.sql and sourced in the 669 version of the database.

I am still getting these messages in game.

You say, '#castspell 278'
Error: #castspell: Arguement out of range

Beginning to memorize Spikecoat...
Unexpected error: spell id out of range

[nosfentora]

Try using #findspell - see if it says spells not loaded.

[Xelaan]

You called it, it says Spells not loaded when I tried to do a #findspell.

When I looked into my DB I can see the spells_new table is populated with 14,000+ rows of data.

Do I need to set something else someplace?

[nosfentora]

yea i was having the same problem and i couldn't figure out why (still can't). i had to recompile my binaries, setting the server to load spells from the files instead of the db table.

i just updated to the 679 binaries, compiled (with database spells) and it works. you may want to either re-download the source and re-compile, or download the compiled binaries (http://code.google.com/p/projecteqemu/downloads/list).

Someone plz correct me if the pre-compiled binaries are not database spell table enabled.

[Xelaan]

The binaries won't work for me as I am running under Debian Linux. I will try recompiling the 679 release. If that doesn't work where is the setting in the ource to repoint to the spells file instead of the db?

[Xelaan]

I also received this error during compile with the 679 release.


clientlist.cpp:229: error: sort was not declared in this scope
clientlist.cpp:231: error: unique was not declared in this scope
clientlist.cpp: In member function void Client::SendChannelMessage(std::string):
clientlist.cpp:1284: warning: suggest explicit braces to avoid ambiguous else
clientlist.cpp: In member function void Client::ChannelModerate(std::string):
clientlist.cpp:1797: warning: suggest explicit braces to avoid ambiguous else
make[1]: *** [clientlist.o] Error 1
make[1]: Leaving directory `/home/eqemu/source/trunk/EQEmuServer/ucs'
make: *** [all] Error 2

[nosfentora]

No idea about compiling under linux, but what you need to change:


change zone/spdat.h


To load spells from the spells_us.txt:

#define NEW_LoadSPDat
//#define DB_LoadSPDat


to load spells from the database:

//#define NEW_LoadSPDat
#define DB_LoadSPDat

[Derision]

I also received this error during compile with the 679 release.


clientlist.cpp:229: error: sort was not declared in this scope
clientlist.cpp:231: error: unique was not declared in this scope
clientlist.cpp: In member function void Client::SendChannelMessage(std::string):
clientlist.cpp:1284: warning: suggest explicit braces to avoid ambiguous else
clientlist.cpp: In member function void Client::ChannelModerate(std::string):
clientlist.cpp:1797: warning: suggest explicit braces to avoid ambiguous else
make[1]: *** [clientlist.o] Error 1
make[1]: Leaving directory `/home/eqemu/source/trunk/EQEmuServer/ucs'
make: *** [all] Error 2


I've added #include <algorithm> to ucs/clientlist.cpp in Rev681. See if that compiles for you now. Odd thing is that it compiled fine for me on Gentoo and Windows without that include.

[Xelaan]

I will try the new release.

[Xelaan]

The new version worked once I switched back to using the spells in the DB. The compile error must have been what was tripping me up earlier.

Thanks again everyone, you guys are teaching me a ton and I appreciate it.

[gaeorn]

I've added #include <algorithm> to ucs/clientlist.cpp in Rev681. See if that compiles for you now. Odd thing is that it compiled fine for me on Gentoo and Windows without that include.

It's probably a gcc version difference on the linux machines. I ran into this problem but was not sure if it was another odd 64bit difference or not (http://www.eqemulator.net/forums/showthread.php?t=28539).

[Yeormom]

I had the same problem, try:

update spells_new set teleport_zone='' where teleport_zone is null;
update spells_new set you_cast ='' where you_cast is null;
update spells_new set other_casts ='' where other_casts is null;
update spells_new set cast_on_you ='' where cast_on_you is null;
update spells_new set cast_on_other ='' where cast_on_other is null;
update spells_new set spell_fades ='' where spell_fades is null;
I ran into this same issue. What is interesting about it crashing in zone/net.cpp when trying to strcpy a null result row is if you change the select statement from order by ascending to descending, it works just fine. This little quark has me scratching my head. :(

Performing a sanity check before copying a null in works just fine but I'm more curious as to what caused this change to appear mroe than anything. Also wish I had not seen the "select *" statement used to populate spells...